Programmatically run Excel calculations

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 VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

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.

1. Create the named range.

   • C#
   • VB

   Microsoft.Office.Tools.Excel.NamedRange NamedRange1 =
       this.Controls.AddNamedRange(this.get_Range("A1"), "NamedRange1");
   

2. Call the Calculate method of the specified range.

   • C#
   • VB

   NamedRange1.Calculate();
   

1. Create the named range.

   • C#
   • VB

   Excel.Range rng = this.Application.get_Range("A1");
   

2. Call the Calculate method of the specified range.

   • C#
   • VB

   rng.Calculate();
   

• Work with ranges
• NamedRange control
• Optional parameters in Office solutions