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 |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com