Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.MoveRowRange Method

Explanation Moves the specified row range to the specified position.

Moves the data and format of the row range. The destination row will be overwritten with the same number of rows as the range of rows to be moved.

Use the MoveRange method to move the cell range and the MoveColRange method to move the column range. Row ranges can be copied or swapped using the CopyRowRange and SwapRowRange methods.
Call format MoveRowRange(row, row2, rowdest)
Return value None
Arguments row The first row number of the range to move
row2 The last row number of the range to move
rowdest The row number to which the row range is moved
Exception EXT-28 An error occurred in the MoveRowRange method
Example of use 
    BlockMode = $TRUE;
    Col = 2;
    Row = 2;
    Col2 = 4;
    Row2 = 4;
    Text = "sample";
    BackColor = $GREEN;
    BlockMode = $FALSE;
    
    MoveRowRange(2, 3, 6);
Related item CopyColRange, CopyRowRange, MoveColRange, MoveRange, SwapColRange, SwapRowRange methods