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?
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?
Check out this KB Entry. 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.