Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named Range Macro Lost Excel Discussion (Misc queries) 1 September 22nd 09 11:17 PM
macro that opens file named in cell doesnt work Illuminati Excel Worksheet Functions 2 November 15th 07 11:49 AM
named cell in macro Pa Maher Excel Discussion (Misc queries) 2 September 19th 07 02:18 AM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
VBA Excel Macro to delete contents in named cell reaa Excel Discussion (Misc queries) 1 January 3rd 06 08:16 PM


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"