Microsoft® Office Excel 2003 Inside Out

Chapter 32. Creating Custom Functions

• 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 Excel includes a multitude of built-in worksheet functions, chances are it doesn't have a function for every type of calculation you perform. Excel's designers couldn't possibly anticipate every calculation need of every user. But they did provide you with the ability to create your own custom functions. In the same way that a macro lets you encapsulate a sequence of actions execute that sequence with a single command, a custom function lets you encapsulate a sequence ...