ListObjects.Item Property

  • Article
Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a ListObjects object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The name or index number of the object.

Example

The following example displays the name of the default list object on Sheet1 of the active workbook.

Visual Basic for Applications 
     
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set oListObj = wrksht.ListObjects.Item(1).Name

See Also