if you only need the array in this formula, add local to start...like:
local numbervar array WorkOrders...
I've heard that shared is the default condition, which would mean that it persists between calls to the formula. I would have thought that the redim would clear it out to default values, but....
HTH
ps if you need the array in other places, you will need to create a reset function that will clear out the newly redimmed array.
Edited by lockwelle - 23 Apr 2012 at 4:51am
IP Logged
