Names Members
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Names Members 

A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.

The following tables list the members exposed by the Names type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
Count Returns the number of objects in the collection. Read-only Integer.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Parent Returns the parent object for the specified object. Read-only.

  Name Description
Add Defines a new name. Returns a Name object.
GetEnumerator Returns an enumerator to support iterating through the collection.
Item Returns a single Name object from a Names collection.
© 2016 Microsoft