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