Excel: Copying Defined Names to Another Worksheet or Macro

ID: Q63028


The information in this article applies to:

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:

  1. Define "test" as =$A$1.


  2. 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        : 

Last Reviewed: March 21, 1999