Item Method

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns a Name object from the Names collection.

expression.Item(Index, IndexLocal, RefersTo)

expression   Required. An expression that returns a Names object.

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.

Remarks

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

Example

This example deletes the name "SortRange" from the workbook.

  Spreadsheet1.ActiveWorkbook.Names.("SortRange").Delete