Check error cell in C#

's Computer Specifications

Hi, All,

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

Thanks,
-Andrew

's Computer Specifications

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

On Jan 9, 9:33 pm, Andrew HUANG
<AndrewHU...@discussions.microsoft.com> wrote:
> Hi, All,
>
> Some cells may be error, such as #REF!. How to know which cell is in error?
>
> Thanks,
> -Andrew

's Computer Specifications

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

On Jan 9, 9:33 pm, Andrew HUANG
<AndrewHU...@discussions.microsoft.com> wrote:
> Hi, All,
>
> Some cells may be error, such as #REF!. How to know which cell is in error?
>
> Thanks,
> -Andrew

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy and move check box (check boxes) with new cell link?	Marty	Microsoft Excel Worksheet Functions	1	20th Jan 2010 07:43 PM
Check for error.type in same cell	art	Microsoft Excel Worksheet Functions	4	13th May 2009 06:14 AM
Check for error.type in same cell	art	Microsoft Excel Worksheet Functions	0	13th May 2009 05:39 AM
Color cell if spell check finds an error	LiveUser	Microsoft Excel Worksheet Functions	3	15th Jan 2008 08:50 PM
Check if Conditional Format is True or False / Check cell Color	=?Utf-8?B?S2V2aW4gTWNDYXJ0bmV5?=	Microsoft Excel Worksheet Functions	5	29th Jun 2007 11:12 AM