VBA - Help with Union All

Hi

I have to track selective blocks of cells in a matrix that is 22 rows deep and
180 columns wide. WHICH blocks I need to track are determined by a drop-down.

Below is a snippet of code I tried using to accomplish this ......

Please Login or Register  to view this content.

Pass 1:
=========
?oRngUnion.Address
$C$2:$F$2,$U$2:$X$2,$AM$2:$AP$2,$BE$2:$BH$2,$BW$2:$BZ$2,$CO$2:$CR$2,$DG$2:$DJ$2,$DY$2:$EB$2,$EQ$2:$ET$2,$FI$2:$FL$2

?oRngUnionAll.Address
$C$2:$F$2,$U$2:$X$2,$AM$2:$AP$2,$BE$2:$BH$2,$BW$2:$BZ$2,$CO$2:$CR$2,$DG$2:$DJ$2,$DY$2:$EB$2,$EQ$2:$ET$2,$FI$2:$FL$2


Pass 2:
=========
?oRngUnion.Address
$C$3:$F$3,$U$3:$X$3,$AM$3:$AP$3,$BE$3:$BH$3,$BW$3:$BZ$3,$CO$3:$CR$3,$DG$3:$DJ$3,$DY$3:$EB$3,$EQ$3:$ET$3,$FI$3:$FL$3

?oRngUnionAll.Address
$C$2:$F$3,$U$2:$X$3,$AM$2:$AP$3,$BE$2:$BH$3,$BW$2:$BZ$3,$CO$2:$CR$3,$DG$2:$DJ$3,$DY$2:$EB$3,$EQ$2:$ET$3,$FI$2:$FL$3

In the 2nd pass the ORIGINAL ranges.addresses on oRngUnionAll are there
but the NEW range address related to oRngUnion have not been included.

I assume that Excel CAN DO this but that my approach is incorrect.

Any help is appreciated.

regards
John

Hello John,

I don't see a problem with the second pass. For example, your original range $C$2:$F$2 when unioned with $C$3:$F$3 will yield a new range of $C$2:$F$3. Did you expect something different?