listobjects item

title keywords f1_keywords ms.prod api_name ms.assetid ms.date ms.localizationpriority

ListObjects object [Excel]

vbaxl10.chm731072

vbaxl10.chm731072

excel

Excel.ListObjects

3a888055-1ed0-d37d-0586-ced999dc1c42

03/30/2019

medium

ListObjects object [Excel]

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

Remarks

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

Example

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

Set myWorksheetLists = Worksheets[1].ListObjects

Methods

  • Add

Properties

  • Application
  • Count
  • Creator
  • Item
  • Parent

See also

  • Excel Object Model Reference

[!includeSupport and feedback]

Video liên quan

Chủ Đề