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