passing arrays between functions in VBA
seems exactly what you were getting at:
Only a variant can be assigned an array
--
Regards,
Tom Ogilvy
"goltinfron" wrote in message
...
Tom thanks, but that is not exactly what I was getting at. Maybe this will
make thing clearer.
function coordinates(coord)
ReDim a(row,column) As Variant
Dim b() As Double
a=coordinates2(coord) 'where coordinates2 is second function
b=coordinates3(a) 'where coordinates 3 is a third function
after this, i go on and do other stuff.
My problem is that I can get the proper answer for a, but when I try to
use a in equation b, it comes up with an error
Sean
|