Using Addins to Store Custom Functions

You might prefer to store frequently used custom functions in an add-in file. A primary advantage of doing this is that the functions can be used in formulas without a filename qualifier.

Assume that you have a custom function named ZapSpaces and that it's stored in Myfuncs.xls. To use this function in a formula in a workbook other than Myfuncs.xls, you need to enter the following formula:

=Myfuncs.xls!ZapSpaces(A1:C12)

If you create an add-in from Myfuncs.xls and the add-in is loaded, you can omit the file reference and enter a formula such as the following:

=ZapSpaces(A1:C12)

I discuss add-ins in Chapter 21.

0 0

Post a comment