Probably a typo. But if you do have your own User Defined Function by that name, you would have to supply the workbook name it is
in, if not in the same workbook. There are ways around that though. A macro can be found in any open workbook but not user
defined functions.

If you have an Excel version prior to 2003 you have an Index in your help, and the # errors are right up at the top on the Index
Tab of HELP.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Christine

It means Excel cannot find the Function referred to in the Formula.

If an Excel Function, possibly you need the Analysis ToolPak Add-in loaded
through ToolsAdd-ins.

If a User Defined Function, it could be that an add-in or workbook with that
Function is not loaded.

If you post the formula that errors, we should be able to give more help.


Gord Dibben Excel MVP

On Fri, 11 Mar 2005 15:51:08 -0800, Christine
wrote:

I need to know what the #NAME means when it appears in a cell that I have
typed a formula in?