faifai
faifai

Reputation: 23

VBA - Creating array storing arrays

I want to create an array storing arrays which stores 4 pieces of information. For example, region "0" is bound by 4 lines, x=1, x=2, y=3, y=4. I want to store the array like this " array[0]=(1,2,3,4)" Similarly, region "1" is bound by x=3, x= 6, y=2, y=3. I want to store the array like this "array[1]=(3,6,2,3)". I have tried to learn about jagged array. But I dont know how to apply it to my case.

Upvotes: 1

Views: 220

Answers (1)

LS_ᴅᴇᴠ
LS_ᴅᴇᴠ

Reputation: 11151

data=Array(Array(1,2,3,4), Array(3,6,2,3), ...) 'This is your data
For region = 0 To 1
    debug.print "Region " & region & ":"
    debug.print "x=";data(region)(0)
    debug.print "x=";data(region)(1)
    debug.print "y";data(region)(2)
    debug.print "y=";data(region)(3)
Next

Upvotes: 1

Related Questions