Hi,
I searched the documentation I have and this web site but, I still cannot figure out how to declare a function that returns an array (in my case a array of strings) of an un-predetermined size. Currently, I use "Public Dim myArray() As String" and then ReDim the array in my Sub. This works but I would much rather declare the Sub as a Function that returns the array of strings. Does anyone know how to do this? Thanks in advance for the help.
Regards,
Vlip
I searched the documentation I have and this web site but, I still cannot figure out how to declare a function that returns an array (in my case a array of strings) of an un-predetermined size. Currently, I use "Public Dim myArray() As String" and then ReDim the array in my Sub. This works but I would much rather declare the Sub as a Function that returns the array of strings. Does anyone know how to do this? Thanks in advance for the help.
Regards,
Vlip