Item Method (QueryTables Collection)

Applies To

QueryTables collection object.

Description

Returns a single QueryTable object from a QueryTables collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a QueryTables object.

Index Required Variant. The index number of the query table.

Example

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

Sheets("Sheet1").QueryTables.Item(1).FillAdjacentFormulas = True