Query(Reference,Boolean) Method

In This Topic

Queries all tables which belong to the specified cell range.

Syntax

'Declaration
 
Public Overloads Function Query( _
   ByVal range As Reference, _
   ByVal intersecting As Boolean _
) As Table()

'Usage
 
Dim instance As Tables
Dim range As Reference
Dim intersecting As Boolean
Dim value() As Table
 
value = instance.Query(range, intersecting)

public Table[] Query( 
   Reference range,
   bool intersecting
)

range: The cell range to query.
intersecting: if set to true, all tables will returns; otherwise, returns only table which belong to the cell range completely.

A Table[] array represents all tables which belong to the specified cell range.