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

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

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