Multidimensional Arrays - VBA
Good afternoon all,
I was wondering if anyone is able to enlighten me as to
an easier way to programatically write in values for
Mulitdimensional Arrays.
In my recent project I worte them as below:
Array(1,0) = "Cat"
Array(1,1) = "Feline"
Array(1,2) = "Tabby"
Unfortunately VBA wouldn't let me write them as per below:
Array(1,"Cat", 'Feline", "Tabby")
So I was wondering if anyone had any other ways so that I
could cut out a couple of hunder rows of code.
Any help would be much appreciated.
Yours sincerely,
Brent McIntyre
|