VBA-Excel return multidimensional array from a function
- by alesdario
I'm trying to write a function which returns a multidimensional array. The problem is that the size of the array isn't defined.
My array is initialized in the function below my_list()
Dim my_list() As String
Public Sub Load_My_List()
Dim last_column As Integer
last_column = some_helper.Get_Last_Column(somw_worksheet)
'my array is…