Hi, can anyone tell me if its possible and if so how i can trigger a macro automatically when a formula result changes a cell? I can get it to trigger when a formula result changes using this...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Target.Cells.Count > 1 Then Exit Sub
On Error GoTo EndMacro
If Not Target.HasFormula Then
Set rng = Target.Dependents
If Not Intersect(Range("A1"), rng) Is Nothing Then
If Range("A1").Value > 200 Then YourMacroName
End If
End If
EndMacro:
End Sub
but it requires human mouse strokes to fire. I want it to do this automatically with no human intervention..
Thanks in advance for any help.
Tricky one?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Target.Cells.Count > 1 Then Exit Sub
On Error GoTo EndMacro
If Not Target.HasFormula Then
Set rng = Target.Dependents
If Not Intersect(Range("A1"), rng) Is Nothing Then
If Range("A1").Value > 200 Then YourMacroName
End If
End If
EndMacro:
End Sub
but it requires human mouse strokes to fire. I want it to do this automatically with no human intervention..
Thanks in advance for any help.
Tricky one?