Search for Text and displaying the results

[ymaster44]

Hi,

I'm trying to set up a system that searches for a string within a range of cells and displays all the results. So far I have been able to display only exact matches, but I'd like to display any matches within a string.

I'm using this code which I found to search for text:

Please Login or Register  to view this content.

I've been trying different ways to check for text within the selected field, but can't seem to get it to work.

Any help would be appreciated, thanks

[JOHN H. DAVIS]

Maybe try:

Changing this line:

Please Login or Register  to view this content.

To one of these?

Please Login or Register  to view this content.

[ymaster44]

That's perfect, thanks very much

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.