| Author |
 Topic  |
|
|
bafaneh
USA
49 Posts |
 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 |
|
|
greg
USA
1379 Posts |
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 =; |
 |
|
| |
Topic |
|
|
|
Row and Column analysis