Hello David,

The Split Function finds its main use in converting CSV files back into
Worksheets. Since the string data is in an array its a quick method
reading the delimited data and transfering it back to the worksheet.
You're right though, it doesn't have much common application in VBA.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=480974