Switching to relative reference for macro

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Older versions of excel had the option to switch to
relative reference when recording macros. This option
doesn't appear available in excel 2002. Anyone know how
you switch to relative reference for recording a macro?
 
Hi

Relative reference is located on the Record Macro toolbar after
clicking Record New Macro.

If that button is not available you will need to put the button back in
using Customise toolbars or Add More Buttons...

Tom
 
Back
Top