ListObject Property

  • Article

As it applies to the Range object.

A Range object property that returns a ListObject object if there is any list object intersecting the specified range. Read-Only.

expression**.ListObject**

*expression   * Required. An expression that returns a Range object.

Remarks

You can use the ListObject property to find out if there is an XML list in a range. This property parallels the PivotTable and QueryTable properties of the Range object in Microsoft Excel. If more than one ListObject object intersects the specified range, the Spreadsheet component will arbitrarily pick one to return.

As it applies to the Workbook object.

Returns a ListObject object.

expression**.ListObject(EntryID)**

*expression   * Required. An expression that returns a Workbook object.

EntryID   Required String. The value of the *ID   * attribute of an MapInfo/Map/Entry in an XML Spreadsheet.

Remarks

Returns a ListObject object for a particular EntryID from an XML Spreadsheet mapping in the <MapInfo> element at MapInfo/Map/Entry.

The XML fragment where the details appear in the XML Spreadsheet file looks something like the following:

<x2:MapInfo xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"> 
   <x2:Map x2:ID="Cust_MapId">
      <x2:Entry x2:ID="example_id" x2:Type="table">
         ...
      </x2:Entry>
   </x2:Map>
</x2:MapInfo>

Example

As it applies to the Range object.

The example below returns the XML list in a the specified range.

ActiveSheet.Range("A1:G9").ListObject

As it applies to the Workbook object.

The example below looks for a specific ListObject object in the active workbook.

Dim objList

Set objList = Spreadsheet1.ActiveWorkbook.ListObject("example_id")

Applies to | Range Object | Workbook Object