Function weirdness - #VALUE, then #NAME, then working fine??
Maybe I shouldn't get too deep into this. Maybe it's just a moon
phase or something. I opened up my workbook this morning and all the
values returned by a Function were showing #VALUE errors. I went over
everything carefully, making sure it was picking up the correct values
from the cells it needed, stepping through the code, etc. Everything
came out okay. So I F5 through the code and F9 on the worksheet - and
everything changed to #NAME errors!
Okay - save and close. Reopen and hour later - and everything is
fine!!?!
Am I the victim of some Excel prank (undocumented "feature", that
is!)? Or was it just my turn in the barrel today?
Ed
|