I am trying to modify the below code to work only if search work "trac" is found. I don't have the search word "trac" in all sheets and it is giving me a problem if "trac" is not found.
Please Login or Register to view this content.
I am trying to modify the below code to work only if search work "trac" is found. I don't have the search word "trac" in all sheets and it is giving me a problem if "trac" is not found.
Please Login or Register to view this content.
Last edited by sroysroy; 10-20-2015 at 01:34 AM.
code tags applied
Last edited by protonLeah; 10-20-2015 at 02:41 PM.
Ben Van Johnson
Try this - the code checks if something is found before continuing:
Please Login or Register to view this content.
Nothing happened. Later I tried after reoping the excel workbook and it worked. Why this happened ?
Last edited by sroysroy; 10-20-2015 at 05:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks