| T O P I C R E V I E W |
| bafaneh |
Posted - 09/07/2011 : 5:11:08 PM
8.5.1
Windows 7
Hi,
I use the following loop to create a column for my analysis, but the numbers that reference the row and columns are specific to one book. I need to batch process my data, so I would like to know if there is a way to reference the beginning and end column values, (i.e. colstart, colend, or something like that).
for (ii=1; ii<=25; ii++)
{
cell(ii,25) = (cell(ii+1,23) - cell(ii,23))/(cell(ii+1,33) - cell(ii,33));
};
Thanks,
Basheer |
| 1 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 09/08/2011 : 2:38:59 PM
To process all columns individually regardless of how many columns you have, then use:
for (ii = 1 ; ii <= wks.ncols ; ii++)
If you do some analysis that accepts a range of multiple columns then you can use 'end' as in:
range raAll = !(1:end);
stats raAll;
stats.mean =; |
|
|
