This topic has not yet been rated - Rate this topic

ListObjects Object (Excel)

Published: July 16, 2012

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

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

The following example creates a new ListObjects collection which represents all the tables in a worksheet.

Set myWorksheetLists = Worksheets(1).ListObjects

Community Additions

© 2014 Microsoft. All rights reserved.