Name Members (Excel)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
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.
Methods
Name |
Description |
|---|---|
Deletes the object. |
Properties
Name |
Description |
|---|---|
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
|
Returns or sets the category for the specified name in the language of the macro. The name must refer to a custom function or command. Read/write String. |
|
Returns or sets the category for the specified name, in the language of the user, if the name refers to a custom function or command. Read/write String. |
|
Returns or sets the comment associated with the name. Read/write String. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Returns a Long value that represents the index number of the object within the collection of similar objects. |
|
Returns or sets what the name refers to. Read/write XlXLMMacroType. |
|
Returns or sets a String value representing the name of the object. |
|
Returns or sets the name of the object, in the language of the user. Read/write String. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns or sets the formula that the name is defined to refer to, in the language of the macro and in A1-style notation, beginning with an equal sign. Read/write String. |
|
Returns or sets the formula that the name refers to. The formula is in the language of the user, and it's in A1-style notation, beginning with an equal sign. Read/write String. |
|
Returns or sets the formula that the name refers to. The formula is in the language of the macro, and it's in R1C1-style notation, beginning with an equal sign. Read/write String. |
|
Returns or sets the formula that the name refers to. This formula is in the language of the user, and it's in R1C1-style notation, beginning with an equal sign. Read/write String. |
|
Returns the Range object referred to by a Name object. Read-only. |
|
Returns or sets the shortcut key for a name defined as a custom Microsoft Excel 4.0 macro command. Read/write String. |
|
Returns True if the specified Name object is a valid workbook parameter. Read-only Boolen. |
|
Returns or sets a String value that represents the formula that the name is defined to refer to. |
|
Returns or sets a Boolean value that determines whether the object is visible. Read/write. |
|
Returns or sets the specified Name object as a workbook parameter. Read/write |