Then I want to copy the col(b) of worksheet named ief$ to col(b) of worksheet named bef$,but I don't know how to access the two worksheets and the two columns.
Better to use range variables to hold your worksheet and columns. And from Origin 8, we supports multiple worksheets in a workbook. Suppose ief$ and bef$ holds the workbook name and both have one worksheet named "sheet1", you can run:
range ra = [ief$]sheet1!col(b);
range rb = [bef$]sheet1!col(b);
rb = ra;
For more about range notation, please read our LabTalk Programming Help.
how to access column of worksheet create by script
Posted - 10/15/2009 : 12:53:33 AM
