Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell/range is in error?
Hello
Is there a simple way of determining if a cell/range is in error? That is, able to tell if it's value is showing "#REF!" or "#NAME!" or "#VALUE?". I want to be able to ignore such cells with a universal test. Is this possible? Thanks in advance for any ideas, Chrisso |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell/range is in error?
dim myCell as range
set mycell = activecell if iserror(mycell.value) then 'it's some kind of error else 'it's not an error end if Chrisso wrote: Hello Is there a simple way of determining if a cell/range is in error? That is, able to tell if it's value is showing "#REF!" or "#NAME!" or "#VALUE?". I want to be able to ignore such cells with a universal test. Is this possible? Thanks in advance for any ideas, Chrisso -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell/range is in error?
Hi,
In addition to the VBA function IsError you have the spreadsheet functions: =ISERROR(A1) =ISERR(A1) =ISNA(A1) which can be employed in the VBE. And you can use the Find Method or the Go To command to locate errors: Selection.SpecialCells(xlCellTypeFormulas, 16).Select It all depends on what you are trying to do. Cheers, Shane Devenshire Microsoft Excel MVP "Chrisso" wrote in message ... Hello Is there a simple way of determining if a cell/range is in error? That is, able to tell if it's value is showing "#REF!" or "#NAME!" or "#VALUE?". I want to be able to ignore such cells with a universal test. Is this possible? Thanks in advance for any ideas, Chrisso |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining if a cell/range is in error?
Ahhh - thanks to you both. Just what I needed.
Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining Cell within Range | Excel Programming | |||
Determining Range of selected cell | Excel Programming | |||
Given a range of cells, some of which contain errors (e.g. #DIV/0), replace each cell having an error with the value of a non-error precedent cell | Excel Programming | |||
Determining range | Excel Programming |