Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET Range | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions | |||
Using Offset to name a range | Excel Worksheet Functions | |||
Define Range with an offset | Excel Discussion (Misc queries) | |||
dynamic range without using OFFSET() | Excel Programming |