Microsoft KB Archive/63028

{|
 * width="100%"|

Excel: Copying Defined Names to Another Worksheet or Macro

 * }

-

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:


 * 1) Define &quot;test&quot; as =$A$1.
 * 2) Enter the formula =test into cell B1.

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

If cell B1 is copied to a new worksheet, &quot;test&quot; will be defined as &quot;=$A$1&quot; 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 &quot;User's Guide 1,&quot; version 4.0. If you are using version 3.0, refer to pages 217-218 in &quot;Microsoft Excel User's Guide.&quot; If you are using Microsoft Excel 2.2, see pages 350-353 in &quot;Microsoft Excel Reference&quot; version 2.2 manual.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :