Please login in order to report media.
Learn macro programming in Excel:
In the Record Macro dialog box, enter a macro name and Shortcut Key (if applicable).
The dialog box disappears, and the Record Macro button changes to a Stop Recording button.
Enter your keystrokes, formulas, and so forth, then click the Stop Recording button and run your macro.