When you record a macro in Excel, the Macro Recorder tool automatically generates VBA code that includes a number of different functions. These functions can be divided into two main categories: built-in functions and user-defined functions. Built-in functions are those that are included as part of the Excel application and are always available to your macros. User-defined functions are those that you create yourself using VBA code. In this article, we'll take a closer look at both types of functions and how they can be used in macros.
As we mentioned, built-in functions are those that are included as part of the Excel application. There are dozens of these functions, and they can be used for a variety of purposes. Some of the most commonly used built-in functions include: