View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How can you change excel macros from absolute to relative?

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