Menu

array UDF not recalculating correctly

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

[email protected] ucdcrush@gmail.com is offline

ucdcrush@gmail.com is offline

external usenet poster

Posts: 9

Default

array UDF not recalculating correctly

nevermind, figured it out.

wrote:
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Function isn't recalculating	Chris	Excel Worksheet Functions	2	May 22nd 09 09:06 AM
TABLE function - not recalculating correctly	Jacob	Excel Worksheet Functions	7	November 16th 07 07:44 PM
Recalculating Array Formulas	andym	Excel Programming	1	July 10th 06 03:53 AM
Stop Recalculating?	stupler	Excel Discussion (Misc queries)	2	March 28th 06 05:37 PM
Array not working correctly Returns FALSE on second part	aaronm49	Excel Discussion (Misc queries)	1	February 11th 05 01:07 AM

All times are GMT +1. The time now is 06:54 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement