Relative range references in VBA - how?
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.
--
Regards,
Tom Ogilvy
"mike" wrote:
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?
|