| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading data into a 2 dimensional array | Excel Programming | |||
| Export 1-dimensional array values to a two-dimensional table? | Excel Programming | |||
| Changing a two-dimensional, one row array to one-dimensional | Excel Programming | |||
| How to generate formula from two dimensional array of data | Excel Worksheet Functions | |||
| sort multi-dimensional array on numeric data? | Excel Programming | |||
Hybrid Mode
