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

  • Thread starter Thread starter neuf
  • Start date Start date
N

neuf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Add to Dynamic Named Range 4
Go to named range nominated by user 3
Set Column choice to a variable from a Drop Down 4
Excel Limit to Named Ranges 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Prompt to enter a macro name? 9
Macro Related to Paste Values 2

Back
Top