Microsoft® Office Excel® 2007 Inside Out

Chapter 27. Creating Custom Functions

Creating a Simple Custom Function

Using Custom Functions

Understanding Custom Function Rules

Using VBA Keywords in Custom Functions

Documenting Macros and Custom Functions

Creating Custom Functions with Optional Arguments

Making Your Custom Functions Available Anywhere

Although Microsoft Office Excel 2007 includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. The designers of Excel couldn’t possibly anticipate every calculation need of every user. But they do provide you with the ability to create custom functions. In the same way that a macro lets you encapsulate a sequence of actions and then execute that sequence with a single command, ...