hi,i have this code for checking $I$1 for two certain values ("live" and "z") and do the precedures
Code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not IsNumeric(Target) And Target.Address = "$I$1" Then
Select Case Target.Value
Case "live"
Call testup1
Call UpdateData
Case "z"
Call StopButton_Click
Call StopButton_Click2
End Select
End If
End Sub
Display More
the problem is that cell $I$1 has formula
and the code doesn't work.if i put these values manualy it works fine.what should i change?i am stuck