| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart allignment issue in 2007 but in 2003 its working fine | Charts and Charting in Excel | |||
| Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
| Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
| Macro fine Run fine from Select but not from KB Shortcut? | Excel Discussion (Misc queries) | |||
| Weirdness | Excel Programming | |||
Threaded Mode
