View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Brent McIntyre Brent McIntyre is offline
external usenet poster
 
Posts: 23
Default 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