Edytuj

Udostępnij za pośrednictwem


Name Interface

Definition

Represents a defined name for a range of cells.

public interface class Name
[System.Runtime.InteropServices.Guid("000208B9-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Name
Public Interface Name
Attributes

Remarks

Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.

Application, Workbook, and Worksheet Objects

The Name object is a member of the Names collection for the Application, Workbook, and Worksheet objects. Use Names(index), where index is the name index number or defined name, to return a single Name object.

The index number indicates the position of the name within the collection. Names are placed in alphabetic order, from a to z, and are not case-sensitive (this is the same order as is displayed in the Define Name and Apply Names dialog boxes, returned by clicking the Name command on the Insert menu).

Use the Name property to return or set the text of the name itself.

Range Objects

Although a Range object can have more than one name, there’s no Names collection for the Range object. Use Name with a Range object to return the first name from the list of names (sorted alphabetically) assigned to the range.

Properties

_Default

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application.

Category

Returns or sets the category for the specified name in the language of the macro.

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.

Comment

Returns or sets the comment associated with the name. Read/write String.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Index

Returns the index number of the object within the collection of similar objects.

MacroType

Returns or sets what the name refers to.

Name

Returns or sets the name of the object.

NameLocal

Returns or sets the name of the object in the language of the user.

Parent

Returns the parent object for the specified object.

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.

RefersToLocal

Returns or sets the formula that the name refers to.

RefersToR1C1

Returns or sets the formula that the name refers to.

RefersToR1C1Local

Returns or sets the formula that the name refers to.

RefersToRange

Returns the Range object referred to by a Name object.

ShortcutKey

Returns or sets the shortcut key for a name defined as a custom Microsoft Excel 4.0 macro command.

ValidWorkbookParameter

Returns True if the specified Name object is a valid workbook parameter. Read-only Boolen.

Value

Returns a string containing the formula that the name is defined to refer to.

Visible

Determines whether the object is visible.

WorkbookParameter

Returns or sets the specified Name object as a workbook parameter. Read/write

Methods

Delete()

Deletes the object.

Applies to