How to: Run Excel Calculations Programmatically
You use a similar process to run calculations in a NamedRange control or a native Excel range object.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
Running Calculations in a NamedRange Control
The following example creates a NamedRange at cell A1 and then calculates the cell. This code must be placed in a sheet class, not in the ThisWorkbook class.
To run calculations in a NamedRange control
Create the named range.
Dim NamedRange1 As Microsoft.Office.Tools.Excel.NamedRange = _ Me.Controls.AddNamedRange(Me.Range("A1"), "NamedRange1")Microsoft.Office.Tools.Excel.NamedRange NamedRange1 = this.Controls.AddNamedRange(this.get_Range("A1", missing), "NamedRange1");Call the Calculate method of the specified range.
NamedRange1.Calculate()NamedRange1.Calculate();
Running Calculations in a Native Excel Range
To run calculations in a native Excel Range
Create the named range.
Dim rng As Excel.Range = Me.Application.Range("A1")Excel.Range rng = this.Application.get_Range("A1", missing);Call the Range.Calculate method of the specified range.
rng.Calculate()rng.Calculate();