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 ?
