Posted to microsoft.public.excel.programming

John Michl[_2_] John Michl[_2_] is offline

external usenet poster

Posts: 27

Fill an Array with String values

Simple question. How do I load a list of strings into an array?

I know I code so the following but it seems inefficient.

Dim a (1 to 20) as String

a(1) = "String1"
a(2) = "String2"
etc...

Can I do something like...

a(1 to 20) = "String1", "String2", "String3" ....."String20"

or

a = Array("String1", "String2", "String3" ....."String20" )

Thanks.

- John Michl
www.JohnMichl.com

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
last number array from string	Michael	Excel Worksheet Functions	17	August 1st 05 07:30 PM
Variant Array with String Values - Type Mismatch	jamiee	Excel Programming	2	March 7th 04 03:39 AM
String to Array Conversion	Ussiddiqui[_14_]	Excel Programming	1	January 31st 04 10:04 AM
Convert a string to an array	Dana DeLouis[_5_]	Excel Programming	0	September 30th 03 04:02 AM
Convert a string to an array	don	Excel Programming	0	September 29th 03 05:08 PM

All times are GMT +1. The time now is 04:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us