ListRows Object
Collapse the table of content
Expand the table of content

ListRows Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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
© 2016 Microsoft