How can you change excel macros from absolute to relative?
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! :)
|