I can't tell what your problem is. What are you starting with and what
are you wanting to end up with?

Alan Beban

Brent McIntyre wrote:
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