VBA - Macro to run on cell change

[seguin85]

Hi,

I know how to get a macro to start when a cell changes, but I am looking to get the same macro to start if cell A1 or cell F1 changes. Is this possible? Can it be modified to accommodate x number of cell changes?

Thanks

 

[James006]

Hi,

You could test following code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Intersect(Target, Range("A1", "F1")) Is Nothing Then Exit Sub
Application.Run ("MyMacro")
End Sub

 

[seguin85]

Thanks James!

Worked perfectly!

 

[James006]

Glad this could help ...

Thanks for the feedback ...