Skip to main content

ListRows object

Table of contents
  1. Remarks
  2. Example

A collection of all the ListRow objects in the specified ListObject object.

Remarks

Each ListRow object represents a row in the table.

Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>