Search function to search if worksheet contains specified text

Hello All-

I have the attached workbook which will search for text throughout the workbook, and then provide the worksheet names that prove true. Unfortunately, this only works if I search for the entire cell content, an EXACT match.

I am trying to manipulate this code so I can search for a partial word, and not the entire cell. FOr instance searching for "BB" should return the worksheets that contain BB, BB01200, as well as 12BB0200.

Any help would be greatly appreciated.

Thank You


Code I am currently using:

Please Login or Register  to view this content.

jaslake - Genius, can't believe I missed it.

Thanks for your help