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