| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read a string from a variant array ?
Need a hint how to get a string from a variant array.
The code I'm using (Excel 2003): Dim MyArray(5) as variant MyArray = array("help",1,2,3,4) note: LBound (MyArr) = 0 Now I don't get anything when using: MsgBox "Check: "+ MyArray(0) or MsgBox "Check: "+ CStr(MyArray(0)) or MsgBox "Check: "+ CVar(MyArray(0)) How to get the string "help" from MyArr ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| ReDim Object array as parameter of Variant array | Excel Programming | |||
| Variant Array with String Values - Type Mismatch | Excel Programming | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
![Tom Emmery[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
