VBA - Creating array storing arrays

Question

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.

What your looking for are multidimensional arrays, if you google "multi dimensional array vba" you get tons of informations. Here is one link: techotopia.com/index.php/Visual_Basic_Multidimensional_Arrays — Doomenik
– Doomenik, Commented Oct 9, 2017 at 13:10
My favorite VBA resource:Excel VBA Introduction Part 25 - Arrays — user6432984
– user6432984, Commented Oct 9, 2017 at 13:12
@Doomenik Generally I don't like them as you can only ReDim last dimension. — LS_ᴅᴇᴠ
– LS_ᴅᴇᴠ, Commented Oct 9, 2017 at 13:17
thanks, I have used multidimensional arrays to solve my problems! — faifai
– faifai, Commented Oct 9, 2017 at 13:24

LS_ᴅᴇᴠ · Accepted Answer · 2017-10-09 13:13:31Z

1

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

answered Oct 9, 2017 at 13:13

LS_ᴅᴇᴠ

11.2k1 gold badge27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA - Creating array storing arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related