Thread: Error trapping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default Error trapping


Hi Group,

I am having a hard time trapping an error and doing what I want to do next.

I am looking up values on a worksheet and it is possible that the value will
be "#N/A". I am comparing two values and the "#N/A" could be one of those
values, so beta(b) = ERROR 2042.

I would like to check if beta(b) does equal ERROR 2042 and then go to the
bottom of my loop.

Thanks for your help.
David