How to read a string from a variant array ?

Posted to microsoft.public.excel.programming

Tom Emmery[_2_] Tom Emmery[_2_] is offline

external usenet poster

Posts: 9

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 ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	6	November 9th 05 05:54 AM
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	1	November 8th 05 04:21 AM
ReDim Object array as parameter of Variant array	Peter T	Excel Programming	4	May 10th 05 02:11 PM
Variant Array with String Values - Type Mismatch	jamiee	Excel Programming	2	March 7th 04 03:39 AM
variant array containing cel adresses convert to actual ranges-array	Peter[_21_]	Excel Programming	5	December 10th 03 09:50 PM

All times are GMT +1. The time now is 11:27 AM.

Menu

About Us