Skip to main content

ListObjects object

Table of contents
  1. Remarks
  2. Example

A collection of all the ListObject objects on a worksheet. Each ListObject object represents a table on the worksheet.


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


The following example creates a new ListObjects collection that represents all the tables on a worksheet.

Set myWorksheetLists = Worksheets(1).ListObjects

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>