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
- 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 Tutorial