Relative range references in VBA - how?

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

When I move a cell that gets info pasted to it via a macro, I have to
readjust the macro. Is there a way to make cell references in script be
relative like in the spreadsheet?

I thought of naming all the cells. I guess that would work, right?

Is there a way without using names?
 
This isn't supported. Using Named Ranges would work.

If there will be label associated with an adjacent cell, then you could use
the find method to locate it.
 
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

VBA set thick borders around non empty cells in range 0
Name a Table relative references 4
Range References in vba 3
Insert Row also adds formulas and moves cursor 2
Name a range with relative reference 2
Combine 2 columns in a dynamic range into one 7
relative reference pivot table macro 2
Best Practice - Cell and Range references in VBA? 5

Back
Top