Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.CopyColRange Method

Explanation Copies the specified column range to the specified position.

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

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