How can you change excel macros from absolute to relative?

[Guest]

These are NOT formulas ok? I want to do the same change to a variety of
different rows/columns in the form of a macro I can run via control key combo
shortcut. How can I do this so that the default macro is not absolute and in
fact only performs the keystroke steps I want the macro to record?

Can anyone help me here???

Thanks for your efforts!

 

[Roger Govier]

Hi
When you invoke the macro recorder, click on the icon to the right of
the stop button before any of your keystrokes to switch to Relative
addressing.

 

[Guest]

Thank you for your response. However, how does one switch to relative
addressing? I THOUGHT I knew Excel but maybe not as well as I imagined lol!

 

[Roger Govier]

Hi

When you choose Tools>Macro>Record New Macro after the clicking OK to
the dialogue box offering you the chance to name the macro, you should
get a small floating Toolbar with the Stop Recording button and a small
graphic to the right of this.
Clicking the small graphic to the right of the Stop button toggles
Absolute to Relative referencing.

Sometimes, this toolbar can disappear if you have stopped the macro
recording in another manner.
To re-invoke it, choose Tools>Macro>Record New Macro
Move the cursor over a toolbar and RIGHT click, then select STOP
RECORDING from the pop-up that appears, and the tool bar will show
itself .
Click the Stop recording button
..
The Floating Toolbar should now re-appear when you try to record another
macro, enabling you to select your Relative addressing.

 

[smartsupport2006]

You can try this EnergyKey
http://www30.webSamba.com/SmartStudio
This may be help you.
Now I always use EnergyKey, it helps me so much in my work.

 

[Guest]

Thank you SOOO much - that's EXACTLY what I wanted to know, Roger! Your
assistance is invaluable, thank you!

Ralonne