Skip to main content

ListObject object

Table of contents
  1. Remarks
  2. Example

Represents a list object in the ListObjects collection.


The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.


Use the ListObjects property of the Worksheet object to return a ListObjects collection.

The following example adds a new ListRow object to the default ListObject object in the first worksheet of the active workbook.

Dim wrksht As Worksheet 
Dim oListCol As ListRow 
Set wrksht = ActiveWorkbook.Worksheets("Sheet1") 
Set oListCol = 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>