2.2.3.12 colswap

Menu Information

Column: Swap Columns

Brief Information

Swap the position of two selected columns

Command Line Usage

colswap rng:= [Book1]Sheet1!(3,1);

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Description

This X-Function swaps two selected columns.

Examples

// This function will swap the positions of the designated columns
// Here we will reverse the order of columns ABCDE to EDCBA
newbook;
wks.ncols = 5;

colswap (1,5);
colswap (2,4);