Excel: Creating a List of the Defined Names in a Document

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.

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.