Go to Deriscope's documentation start pageForceRecalc

*ForceRecalc* is a vba function of the form: *int ForceRecalc(int level, bool errorsOnly)*

It is used to force the recalculation of all referenced formulas.

It takes two arguments and returns and integer.

The first argument (level) is an integer from 0 to 3, interpreted as follows:

*0* for processing the formuals in all open workbooks

*1* for processing the formuals in the active workbook only

*2* for processing the formuals in the active worksheet only

*3* for processing the formuals in the selected range only

The second argument (errorsOnly) is a boolean interpreted as follows:

*FALSE* for recalculating all formulas regardless of their current output.

*TRUE* for processing only those formulas that currently return error.

The returned integer is useful only in the case where *errorsOnly = TRUE*, in which case it equals the number of formulas that ceased to return error after their recalculation.