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