ListObject object (Excel)
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
Properties
- Active
- AlternativeText
- Application
- AutoFilter
- Comment
- Creator
- DataBodyRange
- DisplayName
- DisplayRightToLeft
- HeaderRowRange
- InsertRowRange
- ListColumns
- ListRows
- Name
- Parent
- QueryTable
- Range
- SharePointURL
- ShowAutoFilter
- ShowAutoFilterDropDown
- ShowHeaders
- ShowTableStyleColumnStripes
- ShowTableStyleFirstColumn
- ShowTableStyleLastColumn
- ShowTableStyleRowStripes
- ShowTotals
- Slicers
- Sort
- SourceType
- Summary
- TableObject
- TableStyle
- TotalsRowRange
- XmlMap
See also
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.