I am trying to collect and Range, that is made up of a number o
"sub-ranges" if you like.

I create three ranges the normal way by giving cell references. Thi
works fine and my three ranges hold the values that I need in th
Value2 attribute.

The ranges aren't next to each other and I want to join them into on
range, so I've used the Union() method. This combines the ranges an
if I now use the select method this highlights my range and you can se
that it is the range I'm after.

However the value2 attribute of this combined range, doesn't hold al
the values covered by the range? In fact it only contains values fro
the first range I pass into Union()

Any ideas? Or other solutions to collecting non-contigous ranges

--
richcoleu
-----------------------------------------------------------------------
richcoleuk's Profile: http://www.excelforum.com/member.php...fo&userid=3310
View this thread: http://www.excelforum.com/showthread.php?threadid=52912