| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to "return" the array element number in VBA | Excel Discussion (Misc queries) | |||
| store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
| Search array and return element No | Excel Worksheet Functions | |||
| array functions and complex element values | Excel Worksheet Functions | |||
| Permutations of an array element < to a value | Excel Worksheet Functions | |||
Linear Mode
