Following on from Highlight characters in cell that are not Latin or numbers, since the codes that I need to examine now have symbols, I needed to upgrade the code.
Problem got fuzzy when I tried to exclude parentheses from being colored red. This is the part I’ve changed:
<code>If Not (Char Like "[0-9]" Or Char Like "[A-Za-z]" Or Char Like "[/.,…-]" Or Char Like "[(]" Or Char Like "[)]") Then
</code>
<code>If Not (Char Like "[0-9]" Or Char Like "[A-Za-z]" Or Char Like "[/.,…-]" Or Char Like "[(]" Or Char Like "[)]") Then
</code>
If Not (Char Like "[0-9]" Or Char Like "[A-Za-z]" Or Char Like "[/.,…-]" Or Char Like "[(]" Or Char Like "[)]") Then
Code sometimes works fine, sometimes doesn’t.
Does anyone know a way to make it work, or maybe a better way to represent Latin chars, numbers and special symbols?