Relative Cell Reference when recording macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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.
 
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
 
Back
Top