NamedRange.CalculateRowMajorOrder Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Calculates a specific range of cells.

public:
 System::Object ^ CalculateRowMajorOrder();

public object CalculateRowMajorOrder ();

abstract member CalculateRowMajorOrder : unit -> obj

Public Function CalculateRowMajorOrder () As Object

Returns

Object

An object that represents the calculation of a specific range of cells.

Examples

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();
}

Private Sub CalculateRange()
    Dim myNamedRange As Microsoft.Office.Tools.Excel.NamedRange = _
        Globals.Sheet1.myFormulaRange

    myNamedRange.CalculateRowMajorOrder()
End Sub

Remarks

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.

Applies to

Share via