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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Macro Toolbar 1
My excel macro recorder no longer shows up when recording macro 3
In relation to macros 5
Writing Macros 2
Switch between relative, absolute, and mixed references 3
Relative Reference Button 3
Excel 2007: Help creating a macro that will run Solver? 3
How do I get relative/absolute reference button (macros) 1

Back
Top