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


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
This topic is now closed to further replies.
Sign in to follow this  

  • Create New...

Important Information

Privacy Policy

CTA Templates.png