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

How do I get a macro to ask for a 'range' to go to with a choice of Named ranges?
 

The work has already been done extremely well with the Name Manager addin
which you can get from the authors' sites of Jan Karel Pieterse and Charles
Williams:

www.jkp-ads.com
www.DecisionModels.com

Regards,
Peter T

"neuf" wrote in message
...

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