View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Reading data into a 2 dimensional array

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.