Offset Ranges

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

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
 
Hi

This should do what you want:

Set TargetRange = Range(ActiveCell, ActiveCell.Offset(0, 5))

Regards,
Per
 
Back
Top