| T O P I C R E V I E W |
| masterd |
Posted - 05/11/2006 : 10:16:21 AM
Origin Version (Select Help-->About Origin): 7.5 pro
Operating System: xp pro
Does anyone know the script that can turn several hundred columns from X Y Y Y... to X Y X Y....?!
Also, is there a script that can select last row of the worksheet that contains data. I specifically have to select last row in the worksheet and analyse but number of rows changes between runs to make it harder.
Cheers,
Darko
|
| 2 L A T E S T R E P L I E S (Newest First) |
| masterd |
Posted - 05/11/2006 : 11:14:56 AM
Works, no worries!
I just have to acknowledge great work you guys do!
Keep up good work!
Darko
|
| Mike Buess |
Posted - 05/11/2006 : 10:28:10 AM
Hi Darko,
This will set columns 3, 5, 7, ... as X.
for(i=3;i<wks.ncols;i+=2) {
wks.col$(i).type=4;
};
This will select last row containing data...
wo -s 0 wks.maxrows 0 wks.maxrows;
y1=wks.maxrows-1; // show last row (optional)
Mike Buess
Origin WebRing Member |
|
|
