I need to act upon the test "USA" found in the first three chars of a cell. This is what I did, but I get a compile error. So I did something wrong. How do I compare against specifc characters. Even better, can I use regular expressions.
Code:str = ActiveSheet.Cells(r, c) check = substr(str, 1, 3) If (check = "USA") Then ' do something End If
Bookmarks