Names.Item Method
| Excel Developer Reference |
Returns a single Name object from a Names collection.
Syntax
expression.Item(Index, IndexLocal, RefersTo)
expression A variable that represents a Names object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Index | Optional | Variant | The name or number of the defined name to be returned. |
| IndexLocal | Optional | Variant | The name of the defined name, in the language of the user. No names will be translated if you use this argument. |
| RefersTo | Optional | Variant | What the name refers to. You use this argument to identify a name by what it refers to. |
Return Value
A Name object contained by the collection.
Remarks
You must specify one, and only one, of these three arguments.
Example
This example deletes the name mySortRange from the active workbook.
| Visual Basic for Applications |
|---|
|
See Also