ListObject Object (Excel)

Published: July 16, 2012

Represents a ListObject Object (Excel) object in the ListObjects collection.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft