Worksheet.QueryTables Property

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

See also:

• Worksheet Object
• Worksheet Object Members