Look at the Union Method in the Excel's VBA help.
--
Stefano Gatto


"pmguerra" wrote:


Hi

Can anyone tell me how do I create a range based on other two ranges?
It's kind of concatenating ranges...

eg.:

set myrange_1= range("A1")

set myrange_2= range("B1")

Now I want a range that is based on these two...


Thanks for your help!


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=547642