By Jan Karel Pieterse, MVP

When you write your own functions, also known as User Defined Functions (UDFs), you can place them in add-ins that you then install to use the functions. However, you might get into trouble when the locations of those add-ins change. In this article, Jan Karel explains how to avoid or resolve the #NAME! errors that can occur in that situation.

About the author

Jan Karel Pieterse is a self-employed Excel developer and the owner of JKP Application Development Services, founded in 2003. He has over 20 years of corporate business experience and is an expert in Excel and VBA. Visit his website at http://www.jkp-ads.com for information on his services, many in-depth articles on Excel, and free Excel utilities.

Other articles by this author

• Working with Excel tables in Visual Basic for Applications (VBA)