Share via

QueryTable Object

  • Article
Worksheets (Worksheet)
Aa218985.parchild(en-us,office.10).gifQueryTables (QueryTable)
Aa218985.space(en-us,office.10).gifAa218985.parchild(en-us,office.10).gifParameters (Parameter)

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.

Using the QueryTable Object

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