Relative range references in VBA - how?

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?
 
G

Guest

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.
 

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

Relative references in formulas 3
VBA set thick borders around non empty cells in range 0
Name a Table relative references 4
Range References in vba 3
How do I make references to cells in subroutines relative? 4
Using relative references in macro 3
Relative, Offset, ActiveCell 11
Relative cell references 2

Top