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:

Application.Calculate

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

Worksheets(1).Calculate

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

Worksheets(1).Rows(2).Calculate

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

Calculate in place of:

Application.Calculate

0 0

Post a comment