NamedRange.Calculate Method
Calculates the values of cells in a NamedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function Calculate As Object
Object Calculate()
Return Value
Type: System.Object
Examples
The following code example sets the Formula property of a NamedRange control to calculate the sum of cells A1 through A5, uses the FormulaHidden property to hide the formula, and then calls the Calculate method to calculate the sum of the cells and place the sum in cell A6.
This example is for a document-level customization.
Private Sub CalculateRange()
Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
= Me.Controls.AddNamedRange(Me.Range("A1", "A5"), _
"namedRange1")
Dim namedRange2 As Microsoft.Office.Tools.Excel.NamedRange _
= Me.Controls.AddNamedRange(Me.Range("A6"), _
"namedRange2")
namedRange1.Value2 = 5
namedRange2.Formula = "=SUM(A1:A5)"
namedRange2.FormulaHidden = True
namedRange2.Calculate()
End Sub
private void CalculateRange()
{
Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
this.Controls.AddNamedRange(this.Range["A1", "A5"],
"namedRange1");
Microsoft.Office.Tools.Excel.NamedRange namedRange2 =
this.Controls.AddNamedRange(this.Range["A6"],
"namedRange2");
namedRange1.Value2 = 5;
namedRange2.Formula = "=SUM(A1:A5)";
namedRange2.FormulaHidden = true;
namedRange2.Calculate();
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.