FillAdjacentFormulas Property Example

This example sets query table one so that formulas to the right of it are automatically updated whenever the query table is refreshed.

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