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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
