Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a string to an array
' Parse the comma separated string in the current cell into an array
Dim strArray As Variant Dim intIndex As Integer strArray = Split(ActiveCell.Value, ",") If UBound(strArray) < 0 Then Debug.Print "No string tokens found" Else For intIndex = 0 To UBound(strArray) Debug.Print "Token(" & intIndex & ") = " & strArray(intIndex) Next intIndex End If "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum numbers in cell string array | Excel Worksheet Functions | |||
search text string within array | Excel Discussion (Misc queries) | |||
Can one store a string in a Array element? | Excel Discussion (Misc queries) | |||
last number array from string | Excel Worksheet Functions | |||
Check if a String is inside an Array | Excel Programming |