Im using Split to parse a string with a statment like:
Code:
Dim X As Variant
X = Split(InputData$, "|")
Does anyone know how to see how many fields that Split created because if I try to MsgBox X(99) but the string only contained 98 fields, I get an error, how can I see how many fields it created in X?