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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |