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