Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check error cell in C#
Hi, All,
Some cells may be error, such as #REF!. How to know which cell is in error? Thanks, -Andrew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check error cell in C#
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 wrote: Hi, All, Some cells may be error, such as #REF!. How to know which cell is in error? Thanks, -Andrew |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check error cell in C#
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 wrote: Hi, All, Some cells may be error, such as #REF!. How to know which cell is in error? Thanks, -Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Check for error.type in same cell | Excel Worksheet Functions | |||
Color cell if spell check finds an error | Excel Worksheet Functions | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
How to check whether cell has #REF ! error? | Excel Programming |