View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Emmery[_2_] Tom Emmery[_2_] is offline
external usenet poster
 
Posts: 9
Default 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 ?