Microsoft Excel 2013 Inside Out

Chapter 29. 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 Excel 2013 includes a multitude of built-in worksheet functions, chances are that 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, ...