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.

Use the WorksheetFunction property to place an Excel worksheet function in your VBA procedure. The WorksheetFunction property ...

Get Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.