in addition to Patrick..

have a look at .Resize
it's often used together with .Offset

set r = Range("B1:C10")
set r = r.Offset(0,-1).Resize(,r.Columns.Count + 1)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Douvid" wrote:

Hi,
I have a range, I'm adding a column before the first one
of the range then I need to select a specific range in
that new column according to the first selected range.
Lets say my original range was A2:B5, now the new column
is becoming A and my original range (B2:C5), so how do I
select in that column the range of rows corresponding to
the original range (A2:A5)??
Using the range.offset synthax is selecting a new range of
the size of the original one but I need less than that.
Can someone light my way for that one ???
TKS