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