| 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 | |||
Linear Mode
