In earlier versions of Excel, the #N/A value was a useful way of
communicating "value not available". All cells derived from #N/A were
also designated #N/A.

In Excel 2003, #N/A works the same way, except that Excel now marks
all #N/A cells as errors. (i.e. Excel puts a green mark on the cell
and offers help.)

In my application, #N/A is not an error, and I don't want #N/A cells
to be marked as errors. Is there any way to make that happen?

(By the way, I know I can remove error designations by telling Excel
to ignore them, but that isn't a good solution in this case because my
code would need to parse the entire workbook for #N/A, just to ignore
errors, every time the user makes a change.)


-TC