ListObject Object (Excel)
Represents a table on a worksheet.
The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.
Use the ListObjects property of the **Worksheet**object to return a ListObjects collection. The following example adds a new ListRow object to the default ListObject object in the first worksheet of the active workbook.
Dim wrksht As Worksheet Dim oListCol As ListRow Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set oListCol = wrksht.ListObjects(1).ListRows.Add