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