Microsoft KB Archive/41032

{| = Excel: Pasting Defined Names from One Worksheet to Another =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q41032

SUMMARY
In Microsoft Excel, when a cell containing a formula that uses a defined name is pasted into a new worksheet, the defined name is also pasted into the destination worksheet.

For example, in the source worksheet, cell A1 is named &quot;myName&quot; (myName is set equal to $A$1) and cell A2 contains the formula &quot;=myName&quot;. When the formula is pasted into cell A10 on the destination worksheet, the destination worksheet lists &quot;myName&quot; as a defined name defined as $A$1.
 * }