Display search results inluding results that match patrially

Just got some help to create this macro, but in addition to what I have here I'd like the search results to be displayed if the criteria matches part of the contents of a Cell.

for example I might be searching for a project number 'P12345' and the result should still be displayed if the cell contains 'P00001, P12345'
Is there any way to tweak my code to do this?

Thanks for any help!

Please Login or Register  to view this content.

Hello,
This should work :

Please Login or Register  to view this content.

Hi..

Change this line..

Please Login or Register  to view this content.

to this..

Please Login or Register  to view this content.

And change this...

Please Login or Register  to view this content.

to this..

Please Login or Register  to view this content.

Worked Like a Charm! Cheers dude!

Which solution are you referring to.. mine or GC Excel's..?