Excel: Copying Defined Names to Another Worksheet or Macro

ID: Q63028

The information in this article applies to:

Microsoft Excel for the Macintosh, version 1.x, 2.2, 3.0, 4.0

SUMMARY

In Microsoft Excel, defined names do not copy to another worksheet or macro sheet unless the name is referred to in the copied selection.

For example, on a worksheet (or macro sheet), do the following:

Define "test" as =$A$1.

Enter the formula =test into cell B1.

If cell A1 is copied to a new worksheet, "test" will not be defined on the new worksheet.

If cell B1 is copied to a new worksheet, "test" will be defined as "=$A$1" on this new worksheet.

MORE INFORMATION

This information also applies to a macro sheet. If a macro is copied to another macro sheet, the macro must be defined again on that new macro sheet (using the Define Name command on the Formula menu) so that a key command or a macro name can be used to run the macro.

For more information about the Formula Define Name command, see pages 263-264 in "User's Guide 1," version 4.0. If you are using version 3.0, refer to pages 217-218 in "Microsoft Excel User's Guide." If you are using Microsoft Excel 2.2, see pages 350-353 in "Microsoft Excel Reference" version 2.2 manual.

Additional query words:

Keywords :
Version :
Platform :
Issue type :