Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

ListObject Object

Office 2007
Represents a table on a worksheet.

Remarks

The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.

Example

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



Community Additions

Show:
© 2014 Microsoft