The following code testing the usage of the SPLIT FUNCTION gives me a
run-time
error (on xl2003).
Sub test()
Dim x
Dim txt as String
txt = "abc;xyz;456m;9a6d"
x= Split(txt,";")
Msgbox x
End sub
What am I doing wrong? x is supposed to reurn [abc xyz 456m 9a6d].
David
--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=480974