Excel.Range.QueryTable.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.QueryTable property (Excel)	vbaxl10.chm144183	vbaxl10.chm144183	Excel.Range.QueryTable	6370d43c-74b5-1bb9-f849-c70006432504	05/11/2019	medium

Range.QueryTable property (Excel)

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

Syntax

expression.QueryTable

expression A variable that represents a Range object.

Example

This example refreshes the QueryTable object that intersects cell A10 on worksheet one.

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

[!includeSupport and feedback]