quote:

---

Originally posted by Tobias Hagen


Could you please tell me how this can be done? I tried a for-loop with those:

//Copy String to different book/worksheet:
[Book2]Sheet1!col(A)[1]$=[Book1]1!col(B)[5]$;

//Copy numeric to different book/worksheet
copydata irng:=[Book1]1!col(J)[16] orng:=[Book2]Sheet1!col(B)[1];

That basically works, but I cannot access the col(XXX)[YYY] with the for-loop variable ii.

---

for(int ii = 1; ii <= 5; ii++)
{
    [Book1]Sheet1!col(ii)[ii]$=;
}

[Book1]Sheet1!col(%(ii))[ii]$=;

[Book1]Sheet1!col($(ii))[ii]$=;

[Book1]Sheet1!wcol(ii)[ii]$=;

                                          &&&&&&&&&
                                        &&&
                                       &&
                                      &  _____ ___________
                                     II__|[] | |   I I   |
                                    |        |_|_  I I  _|
                                   < OO----OOO   OO---OO
**********************************************************