reading cell contents
reading cell contents
(OP)
I have an excel file with one worksheet that has 58,000 rows by 170 columns of plant operating data.
What I want to do is examine this data to establish if particular events (such as high steam temperatures) are more likely to occur at particular plant outputs or combinations of auxiliary equipment.
To do this I want to read each row one at a time assigning a variable to each cell in the row which I can then examine. I want to read each row and possibly each cell in the row by loops.
My problem is that I cannot see any easy way to do this. If I want to read the contents of a single cell then I could use X=Range("A1") but with so many cells this seems impractical.
Can anyone help ?
Regards,
athomas236
What I want to do is examine this data to establish if particular events (such as high steam temperatures) are more likely to occur at particular plant outputs or combinations of auxiliary equipment.
To do this I want to read each row one at a time assigning a variable to each cell in the row which I can then examine. I want to read each row and possibly each cell in the row by loops.
My problem is that I cannot see any easy way to do this. If I want to read the contents of a single cell then I could use X=Range("A1") but with so many cells this seems impractical.
Can anyone help ?
Regards,
athomas236





RE: reading cell contents
Cells(1,1).value
This way, it is very easy to replace the R,C reference with a variable.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
RE: reading cell contents
athomas236
RE: reading cell contents
Are you aware that some data are not correlated in the same time instant, so that the output to an input in time t may happen with some lag, say in time t+N*delta t, where N is some integer.In such a case you should construct additional data matrix or make a small code in VBa to correlate inputs at time t with outputs at t+lag.
m777182