Excel.ListObject.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ListObject object (Excel)	vbaxl10.chm733072	vbaxl10.chm733072	Excel.ListObject	46de6c4f-8ce0-0c7d-da59-6e52f5eab612	03/30/2019	high

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

• Delete
• ExportToVisio
• Publish
• Refresh
• Resize
• Unlink
• Unlist

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

• Excel Object Model Reference

[!includeSupport and feedback]