Edit

Share via

Worksheet.QueryTables property (Excel)

  • Article

Returns the QueryTables collection that represents all the query tables on the specified worksheet. Read-only.

Syntax

expression.QueryTables

expression A variable that represents a Worksheet object.

Example

This example refreshes all query tables on worksheet one.

For Each qt in Worksheets(1).QueryTables 
 qt.Refresh 
Next

This example sets query table one so that formulas to the right of it are automatically updated whenever it's refreshed.

Sheets("sheet1").QueryTables(1).FillAdjacentFormulas = True

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.