FillAdjacentFormulas Property

Microsoft Excel Visual Basic

True if formulas to the right of the specified query table are automatically updated whenever the query table is refreshed. Read/write Boolean.

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