To find partial text

Hi

Below is my search and find program. It is fine if I find whole word but it is not working when i try to find partial text.

Seach keyword : max

The following texts available in the rows and the program should find below texts

maxddd
ddmaxfff
ddmax

Please Login or Register  to view this content.

It is not working

Please Login or Register  to view this content.

Please help.

Thanks.

Edited: Sorry, the solution offered didn't work. Try:

Please Login or Register  to view this content.

Regards, TMS

Are you looking at the original solution offered or the revised one? Maybe just check post #2 again.

You probably need to share a sample workbook. I can't keep guessing at what your workbook structure, content and code look like.

I used it to hide rows, rather than unhide them to see if it picked up the right information. Seemed OK.

Regards, TMS

You're welcome. Thanks for the rep.

Sorry for the confusion ... I realised the first solution didn't work and replaced it (no point leaving it there).


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.