Microsoft KB Archive/50092

{| = Excel: Creating a List of the Defined Names in a Document =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q50092

SUMMARY
In Excel versions 2.20 and 3.00, a list of all defined names in a worksheet or macro sheet can be created using the Paste List command.

MORE INFORMATION
Use the following procedure to paste a list of defined names into a worksheet or macro sheet:


 * 1) Select the cell on the sheet that will be the upper-left cell of the pasted information. On a worksheet, the list takes up two columns; on a macro sheet the list takes up four columns. Pasted information replaces any existing values on the sheet, so it is important to highlight a cell in a clear area.
 * 2) Select the Paste Name command from the Formula menu.
 * 3) Click the Paste List button.

Names that have been defined on a worksheet appear in the first column of the paste area, and the cell references or values that the names refer to are listed in the next column to the right. On a macro sheet, the first two columns also contain the names and associated values. The third column contains a 0 (zero) for names that do not refer to macros, a 1 to indicate the corresponding name refers to a function macro, or a 2 to indicate a command macro. The fourth column lists OPTION+COMMAND keys that have been assigned to command macros.

The operation of pasting the list of defined names can be performed by a command macro. The LIST.NAMES macro command is the equivalent of clicking the Paste List button.
 * }