Check error cell in C#

[Andrew HUANG]

Hi, All,

Some cells may be error, such as #REF!. How to know which cell is in error?

Thanks,
-Andrew

 

[feltra]

Assuming this is a question in Excel and not C#, you can key in this
formula in another cell.

Say you key in this formula in Cell N10:
=IF (ISNA(D10), 1, IF(ISERR(D10), 1, 0) )

then, whenever cell D10 gets a # error (such as #REF! #NA etc) cell
N10 will get a 1. If no error, cell N10 will be 0.

Hope this helps.
-feltra

 

[feltra]

On reading your post again, I realised that you may be intereted in
finding out "WHICH" cell is in error and not just HOW to find out
whether a cell is in error?

Well, only way i know is to go thru cell by cell for the desired range
and find out...

-feltra