次の方法で共有


NamedRange.CalculateRowMajorOrder Method

Definition

Calculates a specific range of cells.

public:
 System::Object ^ CalculateRowMajorOrder();
public object CalculateRowMajorOrder ();
abstract member CalculateRowMajorOrder : unit -> obj
Public Function CalculateRowMajorOrder () As Object

Returns

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