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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
