Range.QueryTable (Excel)

Returns a QueryTable object that represents the query table that intersects the specified Range object.

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