Multiple Sheets

[primfran]

I am trying to find cell contents that are potentially on 1 of many sheets in a workbook. I need a procedure to search through multiple sheets to find the cell and have an errorhandler if the criteria is not on any cell.

Can anyone help? :dunno

[Jacob Hilderbrand]

Check out this KB Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=159). Just take out the part where it searches through every workbook in a folder and deal with just the one workbook. Let me know if you need any help modifying the code.