Names.Item Method (Excel)
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.
ActiveWorkbook.Names.Item("mySortRange").Delete