Excel® 2013 On Demand

Creating a Macro

If you find yourself repeating the same set of steps over and over, or if you need to add new functionality to Excel, you could create a macro. If you find it difficult to record a macro, you can create one using a programming language called Microsoft Visual Basic for Applications (VBA). With VBA, you create a macro by writing a script to replay the actions you want. The macros for a particular workbook are stored in a macro module, which is a collection of Visual Basic codes.

Create a Macro

Click the Developer or View tab.

Click the Macros button.

• If you use the View tab, click View Macros on the menu.

Type a name for ...