Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
HP1740
Posted - 05/28/2009 : 05:48:47 AM Hi everyone. here my problem: I want to write a script, that selects every second column (starting with the third in the worksheet), inserts a new column behind every selected one and sets this new columns as Z. so far i only have a script selecting every second column starting with the third one.
toggle = 0; for (ii = 3; ii <= wks.ncols;ii ++) { if (toggle == 0) wks.ColSel(ii,1); toggle = 1-toggle;
};
if i type a command after colsel to insert a new column origin wont do it, or actually breaks down. i hope someone can help me. thanks to all
Florian
1 L A T E S T R E P L I E S (Newest First)
artem
Posted - 05/28/2009 : 12:25:50 PM After the columns are selected, you could use this loop:
for (i=wks.c2; i>=wks.c1; i--) {if (wks.iscolsel(i)) worksheet -i i; };