Microsoft KB Archive/70107

{| = Excel: Undefined Name Has Value =
 * width="100%"|

Last reviewed: November 3, 1994

Article ID: Q70107 The information in this article applies to:
 * Microsoft Excel for the Macintosh, version 3.0

SUMMARY
In Microsoft Excel version 3.0, when an undefined name is typed into a formula in a new macro sheet, Excel should return #NAME? to that cell. If, instead, the cell returns a value or text string, make sure an add-in macro isn't already using that name.

When an add-in macro is installed in Excel 3.0, all macro names become built-in names. Therefore, if there is a add-in macro named &quot;test&quot;, and you type &quot;=test&quot; (without quotation marks) in a new macro sheet, the value of the macro name &quot;test&quot; will be returned to that cell whether or not &quot;test&quot; appears in the Define Name dialog box (on the Formula menu) of the current macro sheet.

MORE INFORMATION
Add-in macros act as if they are built in to Excel. All macro names in add-in macros become the same as built-in names. You cannot change these names (without changing the add-in macro).

If &quot;test&quot; is a macro defined in cell A1 of an add-in macro sheet, and you type &quot;=test&quot; in a new worksheet, the value of A1 on the add-in sheet will be returned to the cell on the new macro. Since &quot;test&quot; is now a built-in name, you cannot change the value of &quot;test&quot; without changing the add-in macro sheet.

For more information on add-in macros, see pages 647-648 of the &quot;Microsoft Excel User's Guide&quot; version 3.0 manual.
 * }