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:
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:
I discuss add-ins in Chapter 21.
Was this article helpful?