View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_2_] Dan E[_2_] is offline
external usenet poster
 
Posts: 102
Default Macro Using Named Cell

JAD

Application.Goto Range("RangeName")
or if your range is on another sheet
Application.Goto ThisWorkbook.Worksheets("SheetName").Range("RangeN ame")

Change RangeName, and SheetName to match your info

Dan E

"JAD" wrote in message
...
I would like to create a multiple number of custom menu
item, on a new toolbar, that will be used to move from one
location to another in my worksheet. My first step was to
name the cells as locations that the menu item icon will
be directed to through a macro. Now that the cells are
named, can I write a macro using the cell name? If so,
could you give me an example of the visual basic required?
Any help would be appreciated.

Thank You,
JAD