View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Program vb to do something in case of an error.

show the code - what line does it error on?

tim

"bjwoodruff"
wrote in message
...

I have read the tips and googled this problem but I cannot find the
answer to it, so I am looking for your help.

My workbook is programed to copy the contents of one cell and find
that
excat match in another workbook. The problem comes up when the macro
cannot find that match in the other workbook so my macro halts
stating
error. How can I program my macro to ignore the error of not finding
that item and move on to the next cell.
Thanks to anyone who can help me.

Benjamin Woodruff


--
bjwoodruff
------------------------------------------------------------------------
bjwoodruff's Profile:
http://www.excelforum.com/member.php...o&userid=24259
View this thread:
http://www.excelforum.com/showthread...hreadid=384427