Export (0) Print
Expand All

How to: Run Excel Calculations Programmatically

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

You use a similar process to run calculations in a NamedRange control or a native Excel range object.

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

  1. Create the named range.

    Microsoft.Office.Tools.Excel.NamedRange NamedRange1 =
        this.Controls.AddNamedRange(this.get_Range("A1", missing), "NamedRange1");
    
  2. Call the Calculate method of the specified range.

    NamedRange1.Calculate();
    

To run calculations in a native Excel Range

  1. Create the named range.

    Excel.Range rng = this.Application.get_Range("A1", missing);
    
  2. Call the RangeCalculate method of the specified range.

    rng.Calculate();
    

Community Additions

ADD
Show:
© 2014 Microsoft