Calculate method

This method calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, depending upon how it is applied.

When applied to the Application object, as in:


Excel will calculate all open workbooks. When applied to a specific worksheet, as in:


Excel will calculate that worksheet. When applied to a specific range, as in:


Excel will calculate the cells in that range. Note that since Calculate is a global method, we can simply write:

Calculate in place of:


0 0

Post a comment