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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My code need to go on a diet 10
help with generating a percentage value 4
Is Range Offset property needed 1
ActiveCell offset delete 5
Absolute to Relative Referencing 3
Select range from ActiveCell do to Lastcell 5
VBA for comparing data within a range for Excel 2003 2
Another Try - Calculate from ActiveCell 9

Back
Top