Link Search Menu Expand Document

SSpread.MoveColRange Method

Explanation Moves the specified column range to the specified position.

Moves the data and format of the column range. The destination column will be overwritten with the same number of columns as the range of columns to move.

Use the MoveRange method to move the cell range and the MoveRowRange method to move the row range. The CopyColRange and SwapColRange methods can be used to copy or swap column ranges.
Call format MoveColRange(col, col2, coldest)
Return value None
Arguments col First column number of the range to move
col2 Last column number of the range to move
coldest Column number of the moved column range
Exception EXT-28 An error occurred in the MoveColRange method
Example of use
    BlockMode = $TRUE;
    Col = 2;
    Row = 2;
    Col2 = 4;
    Row2 = 4;
    Text = "sample";
    BackColor = $GREEN;
    BlockMode = $FALSE;
    
    MoveColRange(2, 3, 6);
    
Related item CopyColRange, CopyRowRange, MoveRange, MoveRowRange, SwapColRange, SwapRowRange methods