NamedRange.CalculateRowMajorOrder Method
Definition
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 -> objPublic Function CalculateRowMajorOrder () As ObjectReturns
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.