Export ranges
 

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

oldjay

Export ranges
 

See if any of this helps -
http://www.microsoft.com/office/comm...9-233d83647308

If not, explain in a little more detail: how do you want to do the
export/copy? Simple copy and paste may be all you need. Or copy and Paste
Special w/Values chosen.

"Oldjay" wrote:

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

oldjay

Export ranges
 

copy the addresses associated with each range into cells in a single column.
Then copy the cells to the other workbook.
--
Gary''s Student - gsnu200736


"Oldjay" wrote:

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

oldjay

Export ranges
 

I should have said defined ranges. The ones you see when you pull down the
name box

"Oldjay" wrote:

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

oldjay

Export ranges
 

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?

"Oldjay" wrote:

I should have said defined ranges. The ones you see when you pull down the
name box

"Oldjay" wrote:

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

oldjay

Export ranges
 

Thanks I was wishing their was a quick way


"JLatham" wrote:

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?

"Oldjay" wrote:

I should have said defined ranges. The ones you see when you pull down the
name box

"Oldjay" wrote:

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

oldjay

Export ranges
 

You're welcome, as always.

"Oldjay" wrote:

Thanks I was wishing their was a quick way


"JLatham" wrote:

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?

"Oldjay" wrote:

I should have said defined ranges. The ones you see when you pull down the
name box

"Oldjay" wrote:

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

oldjay