View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 65
Default 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