View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
neuf neuf is offline
external usenet poster
 
Posts: 1
Default 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