O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required