Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some data in a spreadsheet and want to do some complex things with it.
In the 'old days of GWBASIC' - before spreadsheets - I would set up the following lines of programming:- Dim table(40,60) For i=1 to 40:for j=1 to 60 Read table(i,j) next j:next i Then I would analyse the data in the array. I know that macros can handle the for/next loops but what are the equivalent lines for setting up a 2 dimensional array and then getting the data from the spreadsheet? Any help would be appreciated. Thanks Under Pressure |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Programming style with worksheet functions - discussion invited | Excel Worksheet Functions | |||
How to stop style for col A changing to style of co D date vs $ | Setting up and Configuration of Excel | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
How do I convert US style dates to European style? | Excel Discussion (Misc queries) | |||
A1 style Range in programming | Excel Programming |