oooo
use this code
then change Split to Split2
VB Code:
  1. 'Credit goes to Manavo11 ;)
  2. Private Function Split2(ByVal sString As String, ByVal sSeparator As String) As Variant
  3.     Dim sParts() As String
  4.     Dim lParts As Long
  5.     Dim lPos As Long
  6.         lPos = InStr(sString, sSeparator)
  7.     While lPos
  8.         ReDim Preserve sParts(lParts)
  9.         sParts(lParts) = Left(sString, lPos - 1)
  10.         sString = Mid(sString, lPos + Len(sSeparator))
  11.         lPos = InStr(sString, sSeparator)
  12.         lParts = lParts + 1
  13.     Wend
  14.     If Len(sString) Then
  15.         ReDim Preserve sParts(lParts)
  16.         sParts(lParts) = sString
  17.         lParts = lParts + 1
  18.     End If
  19.     Split2 = IIf(lParts, sParts, Array())
  20. End Function