Names.Item Method (Excel)

Returns a single Name object from a Names collection.

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.

You must specify one, and only one, of these three arguments.

This example deletes the name mySortRange from the active workbook.

ActiveWorkbook.Names.Item("mySortRange").Delete
Show: