Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset Ranges
How do you define a Range based on where the current ActiveCell to 5 Cells to
the Right? Obviously I don't know where the ActiveCell is either Column or Row? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset Ranges
Hi
This should do what you want: Set TargetRange = Range(ActiveCell, ActiveCell.Offset(0, 5)) Regards, Per "Martin" skrev i meddelelsen ... How do you define a Range based on where the current ActiveCell to 5 Cells to the Right? Obviously I don't know where the ActiveCell is either Column or Row? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset Ranges
Per
Thanks, that pointed me in the right direction Martin "Per Jessen" wrote: Hi This should do what you want: Set TargetRange = Range(ActiveCell, ActiveCell.Offset(0, 5)) Regards, Per "Martin" skrev i meddelelsen ... How do you define a Range based on where the current ActiveCell to 5 Cells to the Right? Obviously I don't know where the ActiveCell is either Column or Row? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name groups of .offset ranges | Excel Programming | |||
Dynamic Ranges and Offset | Excel Worksheet Functions | |||
How do I calculate an offset between two ranges? | Excel Programming | |||
Using Offset with named ranges | Excel Worksheet Functions | |||
Ranges using offset | Excel Programming |