Go to Deriscope's documentation start page

ForceRecalc

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.