Thread: arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheIrishThug[_9_] TheIrishThug[_9_] is offline
external usenet poster
 
Posts: 1
Default arrays


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.


--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile: http://www.excelforum.com/member.php...o&userid=29682
View this thread: http://www.excelforum.com/showthread...hreadid=495039