View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Can one store a string in a Array element?

2003/2007

If I: Dim myArray(1 to 2) as long

myArray(1) = "+" does not work as I get a type mismatch.

I thought that array elements were like a Variable.

myArray(1) = 25 works fine

I know that one can initialize an array like array("a", "b")

Why can I not store a string to myArray(1)???

TIA EagleOne