Thread
:
Can one store a string in a Array element?
View Single Post
#
2
Posted to microsoft.public.excel.misc
JE McGimpsey
external usenet poster
Posts: 4,624
Can one store a string in a Array element?
Why can I not store a string to myArray(1)???
Because you dimension myArray as *long*, not *string*
Dim myArray(1 to 2) As String
myArray(1) = "+"
In article ,
wrote:
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
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey