Syntax

expression.FillAdjacentFormulas

expression A variable that represents a QueryTable object.

Example

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

Visual Basic for Applications
Sheets("sheet1").QueryTables(1).FillAdjacentFormulas = True
Automatically calculate adjacent formulas on query update? fill fill adjacent formulas Fill Adjacent Formulas Property filladjacent FillAdjacentFormulas FillAdjacentFormulas Property Recalculate formulas to right of querytable?

See also: