Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return string array from function in excel 97
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return string array from function in excel 97
Fine in 2000 or later, don't recall if it works in '97
-----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL function;find string in entire column & return cell referenc | Excel Worksheet Functions | |||
Reverse a function to return the array? | Excel Worksheet Functions | |||
Can the Excel RTD function return an array (It does on Bloomberg) | Excel Worksheet Functions | |||
Which Function to Use? Search an Array, Return a Row Value | Excel Discussion (Misc queries) | |||
Return array from worksheet function | Excel Worksheet Functions |