Application.Iteration Property (Excel)
True if Microsoft Excel will use iteration to resolve circular references. Read/write Boolean.
Syntax
expression .Iteration
expression A variable that represents an Application object.
Example
This example sets the Iteration property to True so that circular references will be resolved by iteration.
Application.Iteration = True