return any variable type as array

[westconn1]

as the computer i am using does not have VB and only has office 97 i decided i would like to write a replacement for the split function as it is not supported in vba5, however i am having a problem returning an array, i did a search here and the posts indicate this should work

Function split(str As String, c As String) as Variant ()

but it does not like it at all, i get expected end of statement error after variant, also i would like to be able to process any data type, how to be able to do that?

pete