I tried using the macro recorder to find the code if a search comes up blank but no code is generated. I am doing a simple search in a short row using a variable for the "Find". If I get a blank response I want to search the next row with a different variable so I need to know how to handle the negative response of the "Find" search(es) and continue through a loop that checks several rows. I want to use the built in "Find" routine in Excel to search the rows instead of looping through many cells because it may be faster. Also, my search result will be a number from 1 to 5 but there is no "Match Pattern" option in my Excel 2003 Dialog box. This would allow me to use the "#" special character for any single digit as my find criteria. Each positive "Find" result would stop the search so I can process the number in the cell.
Danny
Bookmarks