Return string array from function in excel 97

[Stelio]

Hi all,

Is there a way to return a string array from a function instead of a
variant.
I can return a string array from a function in excel 2000 but in 97
gives me a syntax error.

The following show the definition of my function:

Function SortCollection(ByRef collObject As clcRckColl, ByVal
blnSortRacks As Boolean,ByVal blnSortSlots As Boolean, Optional ByVal
strRackNUm As String) As String()

In particular in 97 doesn't like the last parentheses as string()

Do i have to declare it as Variant and remove the parentheses to make
this macro work for all excel versions?

Any help/suggestions will be appreciated.


Thanks,
Stelio

 

[PAtrick Molloy]

Fine in 2000 or later, don't recall if it works in '97