We help IT Professionals succeed at work.

Excel Arrays

146 Views
Last Modified: 2017-08-05
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 ?
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
NorieAnalyst Assistant
CERTIFIED EXPERT

Commented:
What do you want to do with the data sets?