View Single Post
  #4   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

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