View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default passing arrays between functions in VBA

Only a variant can be assigned an array - however, there usually is no need
to assign it if you pass it through the arguments of the function - but
since you are giving it a new name, I assume you are assigning it.

I would advise against calling your array "Array" since this is a keyword.
--
Regards,
Tom Ogilvy

"goltinfron" wrote in message
...
Ok, this may sound stupid, but, I have a program where I call in a nxm

array, I will call it array0. That array is then sent to another function,
and comes back, I'll call it array1. I then use try to use array1 in another
function, but I get an error message. Do I need to redefine array1 as a
variant before I use in another function?