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