Share via


Name Object Members

Excel Developer Reference

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
Bb242365.methods(en-us,office.12).gif Delete Deletes the object.

Properties

  Name Description
Bb242365.properties(en-us,office.12).gif Application 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.
Bb242365.properties(en-us,office.12).gif Category 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.
Bb242365.properties(en-us,office.12).gif CategoryLocal 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.
Bb242365.properties(en-us,office.12).gif Comment Read/write
Bb242365.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb242365.properties(en-us,office.12).gif MacroType Returns or sets what the name refers to. Read/write XlXLMMacroType.
Bb242365.properties(en-us,office.12).gif Name Returns or sets a String value representing the name of the object.
Bb242365.properties(en-us,office.12).gif NameLocal Returns or sets the name of the object, in the language of the user. Read/write String.
Bb242365.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242365.properties(en-us,office.12).gif RefersTo 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.
Bb242365.properties(en-us,office.12).gif RefersToLocal 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.
Bb242365.properties(en-us,office.12).gif RefersToR1C1 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.
Bb242365.properties(en-us,office.12).gif RefersToR1C1Local 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.
Bb242365.properties(en-us,office.12).gif RefersToRange Returns the Range object referred to by a Name object. Read-only.
Bb242365.properties(en-us,office.12).gif ShortcutKey Returns or sets the shortcut key for a name defined as a custom Microsoft Excel 4.0 macro command. Read/write String.
Bb242365.properties(en-us,office.12).gif ValidWorkbookParameter Read-only
Bb242365.properties(en-us,office.12).gif Value Returns or sets a String value that represents the formula that the name is defined to refer to.
Bb242365.properties(en-us,office.12).gif Visible Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Bb242365.properties(en-us,office.12).gif WorkbookParameter Read/write