| T O P I C R E V I E W |
| TimSch |
Posted - 01/06/2019 : 07:12:49 AM
Origin 2017G (64-bit) SR2; b9.4.2.380
Hello,
another problem I have is:
At the attached images you see three books. I use subtract in Book3 Book2 from Book1, column per column. The first column is the y coordinate. These column I just copy.
Until now I copy the formula of column B(Y) into every following column and change the column character manually.
My questions ist, if there is a possiblity to use a counting variable for the characters of the columns.
Like: range rNe = [Book1]Sheet1!Col(n)
n = column book1 and book2
Thank you for your help!
 |
| 2 L A T E S T R E P L I E S (Newest First) |
| TimSch |
Posted - 01/07/2019 : 03:53:49 AM
Hi,
this help works also! :)
Thank you!
Best Regards
Tim |
| AmandaLu |
Posted - 01/07/2019 : 01:38:05 AM
Hi,
Please use “wcol(j)”. For example, highlight multiple columns, right click and select “Set Multiple Columns Values”. Define such in the “Before Formula Script”
range nB1=[book1]Sheet1!wcol(j);
range nB2 = [book2]Sheet1!wcol(j);
then enter
nB1-nB2
in the formula edit box.
Thanks,
Amanda
OriginLab Technical Service
|
|
|
