View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrisso Chrisso is offline
external usenet poster
 
Posts: 110
Default 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