Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named Range Macro | Excel Discussion (Misc queries) | |||
macro that opens file named in cell doesnt work | Excel Worksheet Functions | |||
named cell in macro | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) |