|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 11th, 2003, 09:16 PM
|
|||
|
|||
Relative Cell Reference when recording macros
Once upon a time, I would get a little box when recording macros and I could click on it to tell it "absolute" or "relative" but now it doesn't show up and I can't figure out how to bring it back out again.
Desired actions: F2 HOME Ctrl v ENTER (moves to next cell) repeat when the macro is called 
|
|
#2
November 11th, 2003, 10:26 PM
|
|||
|
|||
|
Relative Cell Reference when recording macros
Record a macro while doing viewtoolbars and then select stop recording
toolbar, then stop the recording. From now on it should be back -- Regards, Peo Sjoblom "Danadita" wrote in message ... Once upon a time, I would get a little box when recording macros and I could click on it to tell it "absolute" or "relative" but now it doesn't show up and I can't figure out how to bring it back out again. Desired actions: F2 HOME Ctrl v ENTER (moves to next cell) repeat when the macro is called
|
|
#3
November 12th, 2003, 01:07 AM
|
|||
|
|||
|
Relative Cell Reference when recording macros
And DON'T close it while recording or when you want to stop recoding by
hitting the "X" or you will lose it again. Gord Dibben XL2002 On Tue, 11 Nov 2003 17:26:37 -0500, "Peo Sjoblom" wrote: Record a macro while doing viewtoolbars and then select stop recording toolbar, then stop the recording. From now on it should be back
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
