ListRows object (Excel)
A collection of all the ListRow objects in the specified ListObject object.
Each ListRow object represents a row in the table.
Use the ListRows property of the ListObject object to return the ListRows collection.
The following example adds a new row to the default ListObject object in the first worksheet of the workbook. Because no position is specified, a new row is added to the end of the table.
Set myNewRow = Worksheets(1).ListObject(0).ListRows.Add
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.