This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge

Represents a list object in the ListObjects collection.

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 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
Methods
Delete
ExportToVisio
Publish
Refresh
Resize
Unlink
Unlist
Properties
Active
AlternativeText
Application
AutoFilter
Comment
Creator
DataBodyRange
DisplayName
DisplayRightToLeft
HeaderRowRange
InsertRowRange
ListColumns
ListRows
Parent
QueryTable
Range
SharePointURL
ShowAutoFilter
ShowAutoFilterDropDown
ShowHeaders
ShowTableStyleColumnStripes
ShowTableStyleFirstColumn
ShowTableStyleLastColumn
ShowTableStyleRowStripes
ShowTotals
Slicers
SourceType
Summary
TableObject
TableStyle
TotalsRowRange
XmlMap
See also
Excel Object Model Reference
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.