Names Property

         Example         Applies To

Application object: Returns a Names collection that represents all the names in the active workbook. Read-only.

Workbook object: Returns a Names collection that represents all the names in the specified workbook (including all worksheet-specific names). Read-only.

Worksheet object: Returns a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). Read-only.

For information about returning a single member of a collection, see Returning an Object from a Collection.

Remarks

Using this property without an object qualifier is equivalent to using ActiveWorkbook.Names.