How to combine ranges on different worksheets?????

Posted by Ron Dionne on November 01, 2001 11:14 AM

How do I take ranges from several sheets in the
same workbook and combine them into one range on
a new worksheet? I would like to use something similar
to the "Union" method, but it only works on ranges
on the same worksheet, not multiple ones.

Thanks in advance!

Posted by Todd on November 01, 2001 11:21 AM

Have you tried copying one range, pasting onto the other sheet, then doing union?

Posted by Ron Dionne on November 01, 2001 1:32 PM

Can you provide an example please?

Posted by Todd on November 02, 2001 6:12 AM

Re: Can you provide an example please?

I'm assuming you already know how Union works. To find the right syntax to copy the range, record a new macro, perform your actions, then look at the code. You're just copying a range from one sheet to another.