Macro Sheets Only
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
List of Information Functions