MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Relative References


Posted by Matthew Thomson on January 18, 2002 2:13 AM

Using Excel 97 how do you record a macro in relative references rather than absolute. This used to be so easy to do in the previous version of Excel, but now I cannot figure out how to do it.

Thanks in advance


Posted by Robin on January 18, 2002 2:30 AM

Ensure that the relative reference button (next to to stop recording button on the macro toolbar) is switched on.

Robin