Excel.ListRow.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ListRow object (Excel)	vbaxl10.chm741072	vbaxl10.chm741072	Excel.ListRow	ba3e4215-14b6-3dca-82d0-0951f9f2fc3e	03/30/2019	medium

ListRow object (Excel)

Represents a row in a table. The ListRow object is a member of the ListRows collection.

Remarks

The ListRows collection contains all the rows in a list object.

Use the ListRows property of the ListObject object to return a ListRows collection.

Example

The following example adds a new ListRow object to the default ListObject object in the first worksheet of the active workbook. Because no position is specified, a new row is added to the end of the table.

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

Methods

• Delete

Properties

• Application
• Creator
• Index
• Parent
• Range

See also

• Excel Object Model Reference

[!includeSupport and feedback]