Some time ago, I created a custom function to calculated the number of
days sales that can be covered by the current inventory balance
(commonly known as Days on Hand). The function essentially figures out
how many months of demand the inventory can cover and then multiplies
this by an array of days in each month. During testing, the formula
worked fine and there were no errors - there also were no errors when
other groups started using it.

Now, one user is putting the function into a massive file with many
other calculations included. Occassionally, the DOH function returns a
#Name error. Unfortunately, it seems to occur haphazzardly - i.e. it
will error out with a calculation, we can try to calculate, resave, etc
to no avail, and then all of a sudden it will work for no reason. I was
wondering if anyone had run into anything like this. The function has
been a huge time saver, but obviously is of little use if it isn't
reliable. TIA - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=472132