I am trying to create a worksheet change event that calls a macro (private sub stored in same worksheet module as change event).
I need the change event to call the macro when either range("FinalDrop") or range("UpdNmDrop") change values. Both these cells are data validation lists.
I've been messing with this but can't get it to work:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = "FinalDrop" Then
Call AdjustCoopPivots
End If
If Target.Address = "UpdNmDrop" Then
Call AdjustCoopPivots
End If
Application.EnableEvents = True
End Sub
Bookmarks