vba arrays manipulation hard coding syntax [duplicate]

Question

hard coding array manipulation in c based languages is common, like below:

int i[] = new i[2][2];
i = {{1,1},{2,2}};

how it could be done in vba scripts?

Don Kirkby · Accepted Answer · 2013-03-05 06:23:43Z

3

I think you can use the Array() function to build an array of values.

I haven't tried it, but I suspect you could do what you want with this:

Dim i as Variant
i = Array(Array(1, 1), Array(2, 2))

It's been a while, so my VBA is a bit rusty.

answered Mar 5, 2013 at 6:23

Don Kirkby

56.7k28 gold badges225 silver badges307 bronze badges

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

1 Answer 1