FillAdjacentFormulas Property

Applies To

QueryTable object.

Description

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