Range.CalculateRowMajorOrder Method (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Calculates a specfied range of cells.

expression .CalculateRowMajorOrder

expression An expression that returns a Range object.

Return Value


The CalculateRowMajorOrder method calculates the specified range range cell-by-cell, from its top left corner to its to 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.


Other resources