I have a parsetext which encounter a run time error 94 when I run the query make table.
Public Function fnParseText(ParseWhat as Variant, Element as integer, Optional Delimiter as string = ",") as Variant
Dim myArray() as string
myArray = Split(ParseWhat, Delimiter)
if Element < 0 OR Element > ubound(myArray) + 1 then
fnParseText = NULL
fnParseText = myArray(Element - 1)
How do I fix this to have the "" returned if it is null?
Hope I didn't cause more confusion.