QueryTable Property

Microsoft Excel Visual Basic

QueryTable Property

       

Returns a QueryTable object that represents the query table that intersects the specified range. Read-only.

Example

This example refreshes the query table that intersects cell A10 on worksheet one.

Worksheets(1).Range("a10").QueryTable.Refresh