| T O P I C R E V I E W |
| A.Granzhan |
Posted - 09/12/2002 : 12:07:26 PM
Hello everybody...
Does anybody know how to program in LabTalk moving the columns in a workshet? I need the same action as menu command "Column -> Move to First/Last".
Thanks a lot in advance.
A. Granzhan
Universität Regensburg |
| 2 L A T E S T R E P L I E S (Newest First) |
| A.Granzhan |
Posted - 09/13/2002 : 04:55:54 AM
Thanks a lot, this is what I needed.
|
| Mike Buess |
Posted - 09/12/2002 : 12:33:45 PM
These scripts will move the third column of the active worksheet to the beginning or end...
# Move to First
%A=wks.col3.name$; // get the name of column 3
wo -i 0; // insert a column at the beginning
copy col(4) col(1); // copy contents of column 4 (was col 3) to the first column
del col(4); // delete column 4
wo -n 1 %A; // rename the first column
# Move to Last
%A=wks.col3.name$; // get the name of column 3
wo -i wks.ncols; // add a column at the end
copy col(3) wcol(wks.ncols); // copy contents of column 3 to the last column
del col(3); // delete column 3
wo -n wks.ncols %A; // rename the last column
Hope that helps.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 09/12/2002 4:28:04 PM |
