Share via


QueryTables.Item Method

Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a QueryTables object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The name or index number for the object.

Return Value
A QueryTable object contained by the collection.

Example

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

Visual Basic for Applications
  Sheets("sheet1").QueryTables.Item(1).FillAdjacentFormulas = True

See Also