Live Interactive Virtual LearningLive interactive virtual classes are available for our public scheduled courses as well as group or in-house training requests.
Experience training in the comfort of your home or office!
To specify a macro to go to a specific range you can use the Goto method. Here I have already named a range in my worksheet called "Sales". You may also use an alternative method ie the Range select method. Naming a range in excel is recommended rather than specifying an absolute cell reference.
Application.Goto Reference:="Sales" OR Range("Sales").Select