Relative Cell Referencing

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi,

I'm trying to write a macro to capture a variable range,
and the relative reference function I keep seeing is using
Offset. I don't know if it's three rows down or 300.
What is the VB syntax to select end over and end down to
capture the entire range of data? Thanks.

Michael Bulger
 
You must log in or register to reply here.

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

Absolute to Relative Referencing 3
VBA set thick borders around non empty cells in range 0
Using Consolidate Methode with a relative Range 0
Copy to a mid column range Row 10 - Row 20 4
Named Range maker code 9
Create Checkbox and link to relative Cell 3
Dynamic Offset from an Application.Goto cell = Date or Time 10
Cut bottom 300 rows to next sheet & repeat 8

Back
Top