I am looking for a VBA-way to check whether a certain string contains the other string.
string1 = "Hello World"
string2 = "Hello everybody"
teststring = "orld"
String1 contains the teststring, string2 does not.
Is there an easy way?
I was playing around with the worksheetfunction find but this gives an error if the teststring is not found