I created a small UDF which returns a value if the inputs are valid, but
if the inputs are not in the correct range it posts a messagebox with an
error message. If I copy this to a range of cells down a column, it
works great. If I insert a blank row somewhere in the range, no
problem. However, if I then DELETE the blank row, or any other row, all
the functions appear to be recalculated because I get a couple of error
messageboxes corresponding to the couple of inputs that are out of
range. I tried setting the volatile method to false, but no luck. Any
ideas what is going on?


--
timspier
------------------------------------------------------------------------
timspier's Profile: http://www.excelforum.com/member.php...o&userid=32090
View this thread: http://www.excelforum.com/showthread...hreadid=541840