Finding Greek Characters

Demni009 · Jan 8, 2015

I know I can find cells containing a certain number or letter using:

Code:

If cell Like "*V*" Then

But how do I search for a Greek character?

I've tried the following with no luck..

Code:

If cell Like "*ChrW(956)*" Then

Code:

If cell Like *ChrW(956)* Then

Code:

If cell Like ChrW(956) Then

Rick Rothstein · Jan 8, 2015

Try it like this...

If cell Like "*" & ChrW(956) & "*" Then

Scott Huish · Jan 8, 2015

How about:

Code:

If InStr(cell, ChrW(956)) Then

shg · Jan 8, 2015

Maybe one of these:

Code:

  If cell.Value Like "*" & ChrW(956) & "*" Then

  If InStr(cell.Value, ChrW(956)) Then

Demni009 · Jan 8, 2015

Thanks!