Item Method (QueryTables 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.

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