Edit

Share via

Range.QueryTable property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.