Hi.
I have a little problem I cant find a solution to.
I want to use some kind of if statement to check if a cell contains a word starting wiht "int" or "Int"
Cell value can be Intern, international, Internet, Intranet, Intellect, interesting or any other word starting with "int"
I tried:
But it sems like the wildcard * doesn't work here.![]()
If Sheets("Sheet1").Range("A1") = "Int*" Or Sheets("Sheet1").Range("A1") = "int*" Then MsgBox ("Yes!") Else MsgBox ("No!") End If
How do I do this?
Bookmarks