Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Splitting
how do i get VBA to split items that are seperated by a colon ;
ie this;that;andmore split into vars var1 = this var2 = that var3 = andmore Idealy I it would be split into an array |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Splitting
The clue is in the subject
myVar = Split(the_text,";") myVar is then a variant array. -- __________________________________ HTH Bob "Tree*Rat" wrote in message 6.253... how do i get VBA to split items that are seperated by a colon ; ie this;that;andmore split into vars var1 = this var2 = that var3 = andmore Idealy I it would be split into an array |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Splitting
To follow up on Bob's post... you can also declare a dynamic String variable
and assign the Split values to that instead. Dim MyStringArray() As String MyStringArray = Split(YourTextString, ";") Note that all arrays created by the Split function are **always** zero-based arrays (even if you use Option Base 1 in your code modules). -- Rick (MVP - Excel) "Bob Phillips" wrote in message ... The clue is in the subject myVar = Split(the_text,";") myVar is then a variant array. -- __________________________________ HTH Bob "Tree*Rat" wrote in message 6.253... how do i get VBA to split items that are seperated by a colon ; ie this;that;andmore split into vars var1 = this var2 = that var3 = andmore Idealy I it would be split into an array |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Splitting
"Rick Rothstein" wrote in
: To follow up on Bob's post... you can also declare a dynamic String variable and assign the Split values to that instead. Dim MyStringArray() As String MyStringArray = Split(YourTextString, ";") Note that all arrays created by the Split function are **always** zero-based arrays (even if you use Option Base 1 in your code modules). cool, thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting Last Name, First Name | Excel Discussion (Misc queries) | |||
Splitting Text | New Users to Excel | |||
Splitting into Groups | Excel Worksheet Functions | |||
Splitting a Cell | Excel Worksheet Functions | |||
Splitting a cell | Excel Worksheet Functions |