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
|