Posted to microsoft.public.excel.programming

ivan

external usenet poster

Posts: 67

Moving a Variant to Array

I have a ComboBox with a following data (code and name):
12345acb namenamenamenam
123c namenamenamename

and then I need to move only first data (code) to a variant in order to use
in Vlookup. Is an option to move each characters and ending when find the
first blank...? How I can make this?
Thanks for your help.
Ivan

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
ReDim Object array as parameter of Variant array	Peter T	Excel Programming	4	May 10th 05 02:11 PM
Coercing a variant into an array	Alex T	Excel Programming	1	November 18th 04 09:54 PM
Variant Array	Steph[_3_]	Excel Programming	1	June 2nd 04 01:29 AM
Asign Array Variant to Column	William C. Smith	Excel Programming	3	December 27th 03 04:20 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 08:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us