200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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 SubHowever 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 SubAm I missing something? Thanks.
Try this:
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("z_Goto").Address Then
Call MyMacro
End If
End SubChanged "z_Goto" to Range("z_Goto").Address
That should do the trick!