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
Chinmai
Posted - 03/10/2024 : 2:39:41 PM Origin Ver. and Service Release (Select Help-->About Origin): 8.0 Operating System: Windows I have written the following code in the script window. It is not showing error under execution but I do not see any update in the columns range rwks1 = [Book1]Sheet1! for (ii=1; ii<= rwks1.nCols; ii++) { range aa = [Book1]Sheet1!Col(ii)[10106:10251]; Col(ii) = aa; }
Could you please tell where I went wrong?
Thank you
1 L A T E S T R E P L I E S (Newest First)
YimingChen
Posted - 03/11/2024 : 08:29:25 AM Try the script below
range rwks1 = [Book1]Sheet1!;
for (int ii=1; ii<= rwks1!wks.nCols; ii++)
{
range aa = rwks1!wcol(ii)[10106:10251];
wcol(ii) = aa;
}