View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ralonne
 
Posts: n/a
Default 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! :)