MirageSF
asked on
Excel Arrays
Hi,
I know very little about arrays in Excel,
Basically I have sets of data, 400 records, each containing 10 separate rows and 12 columns of data.
If I use say myArray(400,10,12) as variant
Do I then just use myArray=range("A1:Z400") < but cover the 400x10x12 cells?
Then how do I individual reference all these ?
I know very little about arrays in Excel,
Basically I have sets of data, 400 records, each containing 10 separate rows and 12 columns of data.
If I use say myArray(400,10,12) as variant
Do I then just use myArray=range("A1:Z400") < but cover the 400x10x12 cells?
Then how do I individual reference all these ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you want to do with the data sets?