Why Excel Macros?

Excel macros save you time and headaches by automating common, repetitive tasks.

And you don't have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel 2013, it's as simple as recording your keystrokes.

What is VBA used for?

It is an event-driven programming language specifically designed to customize applications that contain the Visual Basic for Applications application-programming interface (API). VBA is used to control the functionality of Microsoft Excel and any other Microsoft Office application.