I want to analyse data in a 2 dimensional array but don't know how to get the
data from the spreadsheet into the aray. In the old days of GWBASIC I would
use the following lines:

Dim Table(100,4)
For I = 1 to 100 : For J = 1 to 4
Read Table(I,J)
Next J : Next I

I know macros can handle FOR/NEXT loops but how do you 'READ' the data that
is, say, in the range A1:D100 ?

Thanks in anticipation.

See your second post.

--
Regards,

OssieMac


"Under Pressure" wrote:

I want to analyse data in a 2 dimensional array but don't know how to get the
data from the spreadsheet into the aray. In the old days of GWBASIC I would
use the following lines:

Dim Table(100,4)
For I = 1 to 100 : For J = 1 to 4
Read Table(I,J)
Next J : Next I

I know macros can handle FOR/NEXT loops but how do you 'READ' the data that
is, say, in the range A1:D100 ?

Thanks in anticipation.