Recalculating Workbooks

The Application object features a couple of methods that enable you to recalculate the open workbooks if you've turned off automatic recalculation:

■ Calculate—Calculates all the open workbooks. Specifically, this method recalculates only those formulas with cell precedents that have changed values. (This is equivalent to pressing F9, or clicking Calculate Now in the Ribbon's Formulas tab.) Note that you don't need to specify the Application object. You can just enter Calculate by itself.

A precedent is a cell that is directly or indirectly referenced in a formula.

0 0

Post a comment