Excel: Undefined Name Has Value

• 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 "test", and you type "=test" (without quotation marks) in a new macro sheet, the value of the macro name "test" will be returned to that cell whether or not "test" 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 "test" is a macro defined in cell A1 of an add-in macro sheet, and you type "=test" in a new worksheet, the value of A1 on the add-in sheet will be returned to the cell on the new macro. Since "test" is now a built-in name, you cannot change the value of "test" without changing the add-in macro sheet.

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