Range.CalculateRowMajorOrder (Excel)
Calculates a specified range of cells.
The CalculateRowMajorOrder method calculates the specified 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.
ActiveCell.CalculateRowMajorOrder