Export ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I export or copy a long list of ranges to another workbook

oldjay
 
copy the addresses associated with each range into cells in a single column.
Then copy the cells to the other workbook.
 
I should have said defined ranges. The ones you see when you pull down the
name box
 
Click on a named range in the list and immediately Excel will go to that
range and select it all. You can then do Copy and Paste easily.

Does that solve the problem?
 
Thanks I was wishing their was a quick way


JLatham said:
Click on a named range in the list and immediately Excel will go to that
range and select it all. You can then do Copy and Paste easily.

Does that solve the problem?
Click to expand...
 
You must log in or register to reply here.

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

Macro Help Please excel 2003 2
Transfering 100 named ranges to an another workbook 2
How to Convert EML to PST? 2
list of named ranges 3
Excel 2003 + export of data 7
How to Export Gmail Emails to PST Format? 4
Excel help please, Button to export data 6
Macro query + excel 2003 8

Back
Top