From the posts thus far, am I right in understanding that
VB Code:
  1. dim strArr() as String
is a STRING array, and
VB Code:
  1. strArr = Split(arg1, arg2)
is a VARIANT populated with strings and that there is a difference between the two?

If so
VB Code:
  1. Private Sub Command1_Click()
  2. Dim strT As String
  3. Dim varT As Variant
  4. Dim strX() As String
  5. Dim varX As Variant
  6.  
  7. strT = "A-TEST-FOR-FINDING-OUT-WHAT-SPLIT-DOES"
  8. varT = "A-TEST-FOR-FINDING-OUT-WHAT-SPLIT-DOES"
  9. MsgBox TypeName(strT)
  10. MsgBox TypeName(varT)
  11.  
  12. strT = varT
  13. MsgBox TypeName(strT)
  14. strT = "A-TEST-FOR-FINDING-OUT-WHAT-SPLIT-DOES"
  15. varT = strT
  16. MsgBox TypeName(varT)
  17.  
  18.  
  19.  
  20. strX = Split(strT, "-")
  21. varX = Split(varT, "-")
  22. MsgBox TypeName(strX)
  23. MsgBox TypeName(varX)
  24.  
  25. strX = varX
  26. MsgBox TypeName(strX)
  27. strX = Split(strT, "-")
  28. varX = strX
  29. MsgBox TypeName(varX)
  30.  
  31. ReDim strX(12) As String
  32. strX(0) = "W"
  33. strX(1) = "H"
  34. strX(2) = "A"
  35. strX(3) = "T"
  36. strX(4) = " "
  37. strX(5) = "I"
  38. strX(6) = "S"
  39. strX(7) = " "
  40. strX(8) = "T"
  41. strX(9) = "H"
  42. strX(10) = "I"
  43. strX(11) = "S"
  44. strX(12) = "?"
  45.  
  46. MsgBox TypeName(strX)
  47. strX = varX
  48. MsgBox TypeName(varX)
  49.    
  50. End Sub
does not show any other result other than STRING() and/or STRING for the variables. Using VarType gives the undifferentiable result of 8200 for both as well, though I am not able to deciphet that result.