Appendix D. Learning VBA Basics for PivotTables
Record a Macro
You can save time and make the process of creating a macro easier by recording some or all the actions you want your macro to perform.
A macro is a sequence of actions, commands, and statements that are executed one after another to perform a specific task. In Excel, as in all the other Office programs that support macros, the macro programming language is called Visual Basic for Applications, or VBA.
VBA is a powerful language that can perform a wide variety of tasks. However, VBA's main task is to operate on the application in which it is running. With Excel VBA, for example, you can create macros that add text and formulas to cells, format ranges, insert or delete worksheets, create ...