Name Properties

Name

Returns

Description

Category

String

Set/Get the category of the Name in the language used to create the macro. Valid only if the Name is a custom function or command

CategoryLocal

String

Set/Get the category of the Name in the language of the end user. Valid only if the Name is a custom function or command

Comment

String

Set/Get any comments associated with a name

Name

Returns

Description

Index

Long

Read-only. Returns the spot where Name is located in the Names collection

IsWorkbook Parameter

Boolean

Set/Get the specified Name object as a workbook parameter

MacroType

XlXLMMacro Type

Set/Get if the Name refers to a command, a function, or just a range

Name

String

Set/Get the name of the Name object in the language of the macro

NameLocal

String

Set/Get the name of the Name object in the language of the end user

RefersTo

Variant

Set/Get the range text that the Name refers to in the language of the macro and in A1 notation style

RefersToLocal

Variant

Set/Get the range text that the Name refers to in the language of the user and in A1 notation style

RefersToR1C1

Variant

Set/Get the range text that the Name refers to in the language of the macro and in R1C1 notation style

RefersTo R1C1Local

Variant

Set/Get the range text that the Name refers to in the language of the user and in R1C1 notation style

RefersToRange

Range

Read-only. Returns the range that the Name refers to

ShortcutKey

String

Set/Get the shortcut key to trigger a Microsoft Excel 4.0 macro associated with a Name

ValidWorkbook Parameter

Boolean

Set/Get the specified Name object if a valid workbook parameter

Value

String

Set/Get the range text that the Name refers to in the language of the macro and in A1 notation style

Visible

Boolean

Set/Get whether the name of the Name object appears in the Names dialog box in Excel

0 0

Post a comment