troubleshooting Question
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 ?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.