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
|