PDA

View Full Version : [SOLVED] Multiple Sheets



primfran
02-02-2005, 07:25 AM
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
02-02-2005, 07:45 AM
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.