View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ucdcrush@gmail.com is offline
external usenet poster
 
Posts: 9
Default array UDF not recalculating correctly

If I do msgbox a, or msgbox reason, I can see that the correct value is
there. However these lines are not populating the array correctly
unless I go in and press ctrl-shift-enter again.

rv(1, 1) = a

rv(1, 2) = c

rv(1, 3) = s

rv(1, 4) = z

rv(1, 5) = lat

rv(1, 6) = lon

rv(1, 7) = acc

rv(1, 8) = reason



geocodeArray = rv