Introduction to Writing Excel Macros
You are not limited to the Built-In Functions
that are provided in Excel.
You can also invent your own functions by writing Excel macros to perform specific tasks.
You can even add your own macros to the Excel function menu, so that they are available to you in the same
way as Excel's built-in functions.
A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA)
The basics of the VBA programming language are covered in the
Excel VBA Tutorial pages of this site.
However, it is recommended that you read the following sections on Excel Macro Security settings and the
Visual Basic Editor, before you begin to write VBA code.