| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
QueryTables.Item method (Excel) |
vbaxl10.chm521075 |
|
|
c7b70ccd-1049-0d50-1536-f1d42b9b1e09 |
05/03/2019 |
medium |
Returns a single object from a collection.
expression.Item (Index)
expression A variable that represents a QueryTables object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Index | Required | Variant | The name or index number for the object. |
A QueryTable object contained by the collection.
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[!includeSupport and feedback]