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

ListRows Object (Excel)

Office 2013 and later
GitHub-Mark-64px

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