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

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