| T O P I C R E V I E W |
| cougar2 |
Posted - 01/06/2004 : 09:15:26 AM Hi everyone,
I´m using the following script to calculate values in worksheet a1 (column f) from worksheet b1 (also column f):
a1_f=(b1_f-b1_f[23])/(b1_f[1]-b1_f[23]);
Can I loop over a certain column range in a1 and b1, say from column b to s? With the wks.col command I cannot access certain values, I guess.
Thank you Cougar
|
| 2 L A T E S T R E P L I E S (Newest First) |
| cougar2 |
Posted - 01/06/2004 : 10:44:59 AM Edgar,
thanks again so much!!
Cougar
|
| edgar.kaiser |
Posted - 01/06/2004 : 10:04:59 AM Cougar,
try wks.cNamen$. n (left to the $) is the column number.
e.g. if you set ii = 2 a1_wks.cName$(ii)$ will refer to a1_b.
Regards,
Edgar
|
|
|