LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Goto a named range using the contents of the active cell

I need a VBA macro that will allow me to use the cell contents of the current
active cell to select a predefined range that exists somewhere in the active
worksheet.

For example, cell a1 includes the text 'ABC'. There is a range in the
worksheet named 'ABC'. I need to select this range using the contents in
cell a1.

Thanks
 
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
Conditional Formatting based on active Named Range; IF Function to VBA Todd[_4_] Excel Worksheet Functions 1 December 1st 11 09:01 PM
copying the contents of a named range from one location to another Steve Excel Discussion (Misc queries) 0 May 22nd 09 08:31 PM
Hyperlink to Named Range Based On Cell Contents TKS_Mark Excel Worksheet Functions 1 January 9th 08 04:14 PM
Is the active cell part of a named range Virginia Excel Programming 1 April 23rd 05 06:46 PM
Test if Active Cell is in a named range Simon Shaw[_5_] Excel Programming 1 September 28th 04 12:11 AM


All times are GMT +1. The time now is 11:49 PM.

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

About Us

"It's about Microsoft Excel"