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! :)

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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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! :)

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" wrote:

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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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! :)

Hi

When you choose ToolsMacroRecord 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 ToolsMacroRecord 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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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" wrote:

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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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! :)

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.

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

Ralonne

"Roger Govier" wrote:

Hi

When you choose ToolsMacroRecord 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 ToolsMacroRecord 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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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" wrote:

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.

--
Regards

Roger Govier


"Ralonne" wrote in message
...
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! :)