Hi,
i bumped into a similar problem
Excel shows a #Name? error
the cell is formatted as general
and Show Formulas is off
for some reason it does not recognize ISERROR function name
after i hit F2 and Enter it shows the result
therefore i assume the formula is OK
F9, Ctrl-Alt-Shift-F9 does not help
any ideas?
the only thing i can think of is that i use VBA to enter the formula and something goes wrong now (but worked before)
thanx,
Sasha
Bookmarks