I want a macro to run if and only if one cell changes. I only want it to run only if cell B2 changes. The macro I have written runs on any change in any cell on the sheet. Any suggestions?
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("B2")) Is Nothing Then
End If
Call Macro2
Call Macro3
Call Macro4
Call Macro5
Call Macro6
Call Fix_Circular_Reference
End Sub
Bookmarks