![]() ![]() ![]() Regardless of where your cursor is positioned when you begin recording the macro, even if it’s already located in cell A1, your first macro keystroke must be Ctrl+Home to make sure you start at Home.Įxample: Imagine that every month you receive dozens of spreadsheets from all your branch offices that you must first combine, then organize, and calculate to produce one monthly report. If you saved your macro in the Personal Macro Workbook (recommended), you can reuse this macro on other worksheets with similar data. Always begin at HomeĪlways begin in the Home position (cell A1)-with your cursor and your data. Record macros using relative cell addresses. Enter your keystrokes, formulas, and so forth, then click the Stop Recording button and run your macro.Click the Relative Reference button next-it turns dark green to indicate that it’s active. The dialog box disappears, and the Record Macro button changes to a Stop Recording button. ![]() Choose Personal Macro Workbook from the Store Macro In drop-down list of choices, enter a description (if desired), and click OK. In the Record Macro dialog box, enter a macro name and Shortcut Key (if applicable).The default in Excel is Absolute, but you can change this to Relative on the Stop Recording toolbar: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |