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
Notice that you have an "End If" immediately following the IF... line; therefore, the if..end if lines do nothing. The code to execute must be between the IF... End If lines.
All you really have is:
On Error Resume Next
Call Macro2 ...
Last edited by protonLeah; 06-07-2012 at 06:29 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks