Excel 2003 macros set relative cell references
Dear Gord - thanks for that David
"Gord Dibben" wrote:
JPI
ToolsCustomizeToolbars.
Select the Stop Recording Toolbar.
Start Recording a macro then hit the Stop button.
DO NOT hit the "x" to stop or you will lose the Toolbar again.
Gord Dibben MS Excel MVP
On Sun, 20 May 2007 19:22:01 -0700, JPI wrote:
Thanks - this is what I thought was supposed to happen, but when I am
recording the macro there are no boxes/toolbars or similar. To stop the
recording I have to go Tools/Macros/Stop Recording - so I don't have the
option to manage the absolute/relative cell references. Can you advise how I
can fix this up. Thanks David
"AKphidelt" wrote:
Oh yea, another thing you can do is... when you are recording the macro,
there should be a little box with a stop button and a little thing next to
it. Click that thing next to the stop button, that will give you a code with
relative references rather then absolute.
"JPI" wrote:
Recording macros for multiple copying and paste it always goes back to the
original cell reference not the subequent cell. Can anybody help stop going
back to original absolute cell reference
|