Export (0) Print
Expand All
Expand Minimize

NamedRange.CalculateRowMajorOrder Method

Calculates a specific range of cells.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Object CalculateRowMajorOrder()

Return Value

Type: System.Object
An object that represents the calculation of a specific range of cells.

The CalculateRowMajorOrder method calculates the specified range cell by cell, from its top-left corner to its bottom-right corner in row-major order. This is the same process that is used by Excel 2000 and earlier versions to calculate a range.

The following code example causes Excel to calculate the specified named range. To run this code example, add a named range control that spans one or more cells that contain some formulas and name it myFormulaRange.

This example is for a document-level customization.

private void CalculateRange()
{
    Microsoft.Office.Tools.Excel.NamedRange myNamedRange =
        Globals.Sheet1.myFormulaRange;

    myNamedRange.CalculateRowMajorOrder();
}

Show:
© 2015 Microsoft