View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Assigning Array Values

Another way

Dim strA

strA = Array("alpha","bravo")

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"MWE " wrote in message
...
Is there a "compact" way of assigning values to arrays, perhaps
something like the FORTRAN DATA statement? Assume a string array,
"strA", dimensioned at (5) and the need to assign values to strA(1),
strA(2), ... perhaps:

Dim strA(10) as String

strA(1) = "alpha"
strA(2) = "bravo"