NAMES macro

Returns, as a horizontal array of text, the specified names defined in the specified workbook. The returned array lists the names in alphabetic order. Use NAMES instead of LIST.NAMES when you want to return the names to the macro sheet instead of to the active worksheet.

Syntax

NAMES(document_text, type_num, match_text)

Document_text    is text that specifies the workbook whose names you want returned. If document_text is omitted, it is assumed to be the active workbook.

Type_num    is a number from 1 to 3 that specifies whether to include hidden names in the returned array.

If type_num is NAMES returns
1 or omitted Normal names only
2 Hidden names only
3 All names

Match_text    is text that specifies the names you want returned and can include wildcard characters. If match_text is omitted, all names are returned.

Remarks

 

Example

The following macro formula returns all names on the active workbook starting with the letter P.

NAMES(, 3, "P*")

Related Functions

DEFINE.NAME   Defines a name on the active worksheet or macro sheet

DELETE.NAME   Deletes a name

GET.DEF   Returns a name matching a definition

GET.NAME   Returns the definition of a name

LIST.NAMES   Lists names and their associated information

SET.NAME   Defines a name as a value

Return to index