Microsoft Excel 2019 Inside Out

Chapter 19Automating Repetitive Functions Using VBA Macros

Checking Security Settings Before Using Macros

Recording a Macro

Case Study: Macro for Formatting for a Mail Merge

Everyday-Use Macro Example: Formatting an Invoice Register

Understanding VBA Code—An Analogy

Using Simple Variables and Object Variables

Customizing the Everyday-Use Macro Example: GetOpenFileName and GetSaveAsFileName

From-Scratch Macro Example: Loops, Flow Control, and Referring to Ranges

Combination Macro Example: Creating a Report for Each Customer

Every copy of Excel shipped since 1995 has included the powerful Visual Basic for Applications (VBA) lurking behind the grid. With VBA, you can do anything that you can do in the regular interface, and you can do it much ...