Skip to main content

ListRow object

Table of contents
  1. Remarks
  2. Example

Represents a row in a table. The ListRow object is a member of the ListRows collection.


The ListRows collection contains all the rows in a list object.

Use the ListRows property of the ListObject object to return a ListRows collection.


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

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>