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

--
pmguerr
-----------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...fo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=54764