Thread: range offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Douvid Douvid is offline
external usenet poster
 
Posts: 11
Default range offset

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