Hi,
I am not sure which version of Origin you are using. I have tried your script in Origin 7.5, Origin 8 SR6 and Origin 8.1 SR3, and it works fine. I have added one more script to output the values in column A for debugging, you can also have a try:
for(col=1; col<=10; col++)
{
Book2_A(col)=;
Book2_B$(col) = Book2_B$(col)/Book2_A(col);
}
By the way, if you are using Origin 8 or Origin 8.1, you can try the following script.
// suppose your data in Sheet1 of Book2
range rColA = [Book2]Sheet1!col(a);
for(ii = 1; ii<=10; ii++)
{
range rCol = [Book2]Sheet1!col(B$(ii));
rCol = rCol/rColA[ii];
}
Penn
negative values
Posted - 05/24/2010 : 07:18:37 AM
