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

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.