Item Method

Microsoft Office Web Components Visual Basic

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. This argument is not supported.

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