This documentation is archived and is not being maintained.

ListObject Object

Office 2007
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 Worksheetobject 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.

Visual Basic for Applications
Dim wrksht As Worksheet
Dim oListCol As ListRow
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set oListCol = wrksht.ListObjects(1).ListRows.Add