Jump to content
Sign in to follow this  
Milton Cordova

Ejecuta macro cambio 2 celdas

Recommended Posts

Saludos deseo ejecutar una macro cuando se cambien 2 celdas, encontre una macro para un rango, pero deseo que sea para la celda A5 y B6

gracias

Private Sub Worksheet_Change(ByVal Target As Range)

Dim KeyCells As Range

' The variable KeyCells contains the cells that will

' cause an alert when they are changed.

Set KeyCells = Range("A1:C10")

If Not Application.Intersect(KeyCells, Range(Target.Address)) _

Is Nothing Then

' aqui va la macro

End If

End Sub

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  



×
×
  • Create New...

Important Information

Privacy Policy


CTA Templates.png