Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.MoveRange Method

Explanation Moves the cell block to the specified position.

Moves the data and formats in the cell block. The destination cell will be overwritten with the same range as the source cell block.

Use the MoveColRange method to move the column range and the MoveRowRange method to move the row range.Cell blocks can be copied or replaced using the CopyRange and SwapRange methods.
Call format MoveRange(col, row, col2, row2, coldest, rowdest)
Return value None
Arguments col Column number of the upper left cell of the cell block to move
row Row number of the upper left cell of the cell block to move
col2 Column number of the lower right cell of the cell block to move
row2 Row number of the lower right cell of the cell block to move
coldest Column number of the upper left cell of the destination cell block
rowdest The row number of the upper left cell of the destination cell block
Exception EXT-28 An error occurred in the MoveRange method
Example of use 
    BlockMode = $TRUE;
    Col = 2;
    Row = 2;
    Col2 = 4;
    Row2 = 4;
    Text = "sample";
    BackColor = $GREEN;
    BlockMode = $FALSE;
    
    MoveRange(2, 2, 3, 3, 6, 6);
Related item ClearRange, CopyRange, MoveColRange, MoveRowRange, SwapRange methods