| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative range references in VBA - how?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| relative references | Excel Discussion (Misc queries) | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Relative references | Excel Discussion (Misc queries) | |||
| Relative references | Excel Discussion (Misc queries) | |||
Linear Mode
