i have a function that returns an array. how do i need the Dim the variable so that vba will allow me to have Variable = FunctionReturningArray
leaving the variable as a variant works, but hogs memory.
i tried "dim variable(0 to 5) as string", but this does not work.
Bookmarks