This works great when I click in the cell and change the value:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("VB_Trigger").Address Then
How can I trigger this code if "VB_Trigger" is a self change formula from other cells?
ie; VB_Trigger is =D10+D11 so it changes on it's own and my trigger doesn't get tripped.....
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("VB_Trigger").Address Then
How can I trigger this code if "VB_Trigger" is a self change formula from other cells?
ie; VB_Trigger is =D10+D11 so it changes on it's own and my trigger doesn't get tripped.....