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?
|