How to: Run Excel Calculations Programmatically
Some code examples in this topic use the this or Me keyword or the
Themethod runs all calculations in the specified object. Use the method of the object that limits the calculation range to the smallest number of cells that you want to recalculate. The recalculation engine in Microsoft Office Excel 2003 is very fast, but if you can limit the number of cells involved, you can optimize the operation.
Running Calculations for a Range
To run calculations in a NamedRange control
Create the named range.
Call the Calculate method of the specified range.
Running Calculations for the Entire Application
Compiling the Code
This code must be placed in a sheet class, not in the