Relative Cell Reference when recording macros

D

Danadita

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
F
HOM
Ctrl
ENTE
(moves to next cell

repeat when the macro is called
 
P

Peo Sjoblom

Record a macro while doing view>toolbars and then select stop recording
toolbar,
then stop the recording. From now on it should be back


--

Regards,

Peo Sjoblom

Danadita said:
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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top