Convert a string to an array
Just one general idea...
Sub Demo()
Dim s As String
s = "item1,item2,item3,item4,item5"
[A1:A5] = WorksheetFunction.Transpose(Split(s, ","))
End Sub
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"pk" wrote in message
...
Does anyone know an easy/efficient method for converting a
comma separated string into a single column array?
i.e. string is passed in this format:
item1,item2,item3,itemx...
I need to parse and copy into an array.
Your example code would be greatly appreciated...thanks in
advance.
|