| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get a macro to ask for a 'range' to go to with a choice of Named ranges?
I have a basic spreadsheet that has a number of named ranges on it. I've created a macro that performs some basic operations. I want to be able to copy and paste specific Named Ranges to another sheet. To do this, I want a dialog box to ask me which range I want to select by offering me either a pulldown menu with the Range Name options, or the actual 'Go To' dialog box to appear where I can just select the appropriate range. Any suggestions? neuf -- neuf ------------------------------------------------------------------------ neuf's Profile: http://www.excelforum.com/member.php...o&userid=24043 View this thread: http://www.excelforum.com/showthread...hreadid=376536 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
| Range matching multiple named Ranges | Excel Discussion (Misc queries) | |||
| Charting only Used Range with Named Ranges | Charts and Charting in Excel | |||
| Excel will not include all of my non-adj ranges in a named range?? | Excel Worksheet Functions | |||
| Deleting named ranges by looping through range collection | Excel Programming | |||
Threaded Mode
