Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I record a macro with relative cell addresses?
When running a macro to enter date in several different cells, the entries
always are made in the original cell addresses that were used during recording. I want to record a macro that allows "relative" cell movement instead of "absolute" (with reference to the starting cell). I seem to recall there was an option available to do this at one time, but I can't recall what it was. I'm using MS Office Excel 2003. |
#2
|
|||
|
|||
How do I record a macro with relative cell addresses?
What you need is the Stop Recording toolbar, it has the relative button.
It's a little hard to find: 1. start recording a dummy macro 2. pull-down View Toolbars and make sure the Stop Recording bar is checked 3. closeout the dummy macro. -- Gary's Student "Tony IA" wrote: When running a macro to enter date in several different cells, the entries always are made in the original cell addresses that were used during recording. I want to record a macro that allows "relative" cell movement instead of "absolute" (with reference to the starting cell). I seem to recall there was an option available to do this at one time, but I can't recall what it was. I'm using MS Office Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Ranges in excel macro | Excel Discussion (Misc queries) | |||
Relative Ranges in excel macro | Excel Worksheet Functions | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) |