Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

QueryTable Object (Excel)

Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database.

The QueryTable object is a member of the QueryTables collection.

Use QueryTables(index), where index is the index number of the query table, to return a single QueryTable object. The following 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
Show:
© 2015 Microsoft