Microsoft Excel 2013 Inside Out

Chapter 28. Recording macros

• Configuring macro security

• Using the macro recorder

• Introducing the Visual Basic Editor

• Learning the basics of Visual Basic

• Adding code to or editing recorded macros

• Using subroutines in macros

• Going on from here

A MACRO is a set of instructions that tells Microsoft Excel 2013 (or another application) to perform one or more actions for you. Macros in Excel 2013 are like computer programs, but they run completely within Excel. You can use them to automate tedious or frequently repeated tasks.

Macros can carry out sequences of actions much more quickly than you can yourself. For example, you can create a macro that enters a series of dates across one row of a worksheet, centers the date in each cell, and then applies a border ...