MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Recording Macros in Absolute vs Relative mode


Posted by Lori on July 22, 2001 10:26 AM

Okay- I've got my trusty little "Excel 5 for Windows" book here with me. Of course the software I'm working with is "Excel 97". Not really too many differences, except that I am trying to record a macro in relative mode (Excel 5 supposedly gives you the option with a toggle button in the tools menu) I see no such option in Excel 97. When recording macros, does anyone out there know how to record in absolute mode? Thanks!


Posted by Lori on July 22, 2001 10:29 AM

Sorry, I meant to ask "Does anyone out there know how to record in "Relative" mode? Thanks again!


Posted by Lori on July 22, 2001 10:51 AM

Duh! Never mind- I found it.... After you choose record, it's the button to the right of the "Stop" button.