I have a macro set up so that when a cell changes a macro is called. It works perfectly fine when the target address is a cell reference.
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then
Call MyMacro
End If
End Sub
However if I change the address to a name reference, it stops working.
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "z_Goto" Then
Call MyMacro
End If
End Sub
Am I missing something? Thanks.