Ignoring case in text search

[CDandVinyl]

Hi All

I'm using

If cell.Text Like ("*" & mytext & "*")

to find the text ("mytext") I input in cell G3 within any worksheet of my workbook. If it finds the text it colours it red in the cell it which it finds it.

This works fine to a point. Unfortunately , it doesn't work if the input text is in a case different to the cells it's looking in.

For example , if I enter 'John' and there is a cell which matches this , it will find it. If I enter 'john' it won't.

How can I amend my code to find the input text , ignoring case? I'd like to enter 'John' and find both 'John' and 'john'.

Grateful for any advice.

[YasserKhalil]

Hello
You can use LCase or UCase

Please Login or Register  to view this content.

[sktneer]

You may try one of the following methods...

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[CDandVinyl]

Many thanks for your help. This is working perfectly now.

[sktneer]

You're welcome! Glad we could help.