Why does that stop you using Union?

--
HTH

Bob Phillips

"Sunil Patel" wrote in message
...
how can i do this . I cannot use Union as the order in which the cells are
looked at changes.

rngTarget =

Range("B3:C11,E3:F11,H3:I11,K3:L11,N3:O11,Q3:R11,T 3:U11,B12:C20,E12:F20,H12:
I20,K12:L20,N12:O20,Q12:R20,T12:U20,B21:C29,E21:F2 9,H21:I29,K21:L29,N21:O29,
Q21:R29,T21:U29,B32:C40,E32:F40,H32:I40,K32:L40,N3 2:O40,Q32:R40,T32:U40,B41:
C49,E41:F49,H41:I49,K41:L49,N41:O49,Q41:R49,T41:U4 9,B50:C58,E50:F58,H50:I58,
K50:L58,N50:O58,Q50:R58,T50:U58")