Chapter 7. Using Excel Worksheet Functions
Work with Excel Worksheet Functions
A function is a block of code that performs a task and returns a value. There are three types of functions: VBA functions, Excel worksheet functions, and custom functions. A VBA function is a function supplied by VBA. An Excel worksheet function is a formula that Excel has predefined. You can use them to do things such as add numbers, find an average, or find the highest number in a list. Excel provides you with more than 300 worksheet functions. Custom functions work like worksheet functions; however, you define the formula the function uses.
WorksheetFunction property to place an Excel worksheet function in your VBA procedure. The
WorksheetFunction property ...