"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