What is VBA in Excel? Record a Simple Macro

Imagine you could teleport from New York City to Sydney, Australia, in five seconds. Would you bother taking the traditional 22-hour flight? Of course you wouldn’t.

Imagine you could create a full Excel report with tables and charts in five seconds with one mouse click. Would you want to know how? Or would you rather craft the report by hand and use 22-hours of your life in the process?

If you answered “yes” to the five-second option, then VBA and Macros in Excel are just what you are looking for.

Think of a situation where you find yourself in Excel performing the same set of steps, over and over. This is a prime candidate for using a macro.

Imagine performing the following processes in Microsoft Excel with a single click:

• Save each sheet in a workbook as a separate file.
• Send a sheet to a co-worker as an email attachment.
• Sort all sheets in a workbook.
• Remove all comments, hyperlinks, images, or personal information from a workbook.
• Replace all Excel functions with function results.
• Format all tables with proper colors, fonts, and other cosmetic features.
• Refresh all reports (or Pivot Tables) in a workbook.

Recommended Learning Platform course

Unlock Excel VBA and Excel Macros

Leila Gharani