colmove

Menu Information

Move Columns

Move selected columns

1. colmove r:=col(1) operation:=last;

2. colmove r:=col(2):col(4) operation:=first;

3. colmove r:=col(3) operation:=left;

4. colmove r:=col(2) operation:=right;

Display Name	Variable Name	I/O and Type	Default Value	Description
Columns	rng	Input/Output Range	<active>	Specifies the columns to be moved.
Operation	operation	Input int	first	Specifies the operation to execute on the columns. Option list first:Moveto First Moves the selected columns to the first worksheet column position. last:Move to Last Moves the selected columns to the last worksheet column position. right:Move Right Moves each selected column one column to the right. left:Move Left Moves each selected column one column to the left.

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Columns

rng

Input/Output

Range

Specifies the columns to be moved.

Operation

operation

Input

int

first

Specifies the operation to execute on the columns.
Option list

first:Moveto First
Moves the selected columns to the first worksheet column position.
last:Move to Last
Moves the selected columns to the last worksheet column position.
right:Move Right
Moves each selected column one column to the right.
left:Move Left
Moves each selected column one column to the left.

This X-Function moves the specified columns to new positions in the same worksheet, allowing user to rearrange the columns.