User defined function not recognized

  • Thread starter Thread starter Salman
  • Start date Start date
S

Salman

I have two user defined functions saved in my
personal.xls. One of them works fine in any workbook. The
other returns #NAME? when I use it till I copy the code
from personal.xls and save it to the workbook i am working
in at the time. In personal.xls the code for both
functions is saved on the same page. Any suggestions?
Thanks
 
Would like to see the code behind the udf's.
My first check woul be to see if the udf calls another
function that's not referenced by personal.xls

Patrick Molloy
Microsoft Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

functions in 'personal.xls' 4
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
personal.xls 2
Use External Function 1
Call Macro from PERSONAL.XLS 4
Create employee attendance db using personal.xls? 3
Project Code Communication 2
Macro for all Excel Workbooks to print to PDF 2

Back
Top