Definition:
An Excel macro is a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet. Macros are used to eliminate the need to repeat the steps of common tasks over and over. Tasks such as adding or removing rows and columns, protecting or unprotecting worksheets, selecting a range of cells, or adding the current date to a spreadsheet.
In Excel, macros are written in Visual Basic for Applications (VBA). For those who cannot write VBA code, Excel allows you to record a series of steps - using keyboard and mouse - that Excel then converts into VBA.
Related Article
Examples:
Creating a macro using Excel's record macro option is a quick and easy way for users to eliminate those repetitive tasks, such as adding or removing columns and rows, that regularly occur while building a spreadsheet.
