It's looking for whole matches and it is not case sensitive.
If you searched for say "My Text"...
Matched:
"MY TEXT"
"my text"
No Match:
"MyText"
"This is My Text"
" My Text"
"My Text "
Surround the text with asterisks for a contains-type match e.g.; "*My Text*"
Matched:
"This is My Text"
"my Text"
This is My Text again"
No Match:
"MyText"
"My Text with two spaces in between"
Perhaps you can search for something like...
strFind1 = "*Point to Point*"
strFind2 = "*RPK*"
...if that is exclusive enough, but allows for possible variances in other parts of the strings.
Also, you could only successfully search a sheet one time because it inserts a column. It wouldn't find matches on a second search unless you delete column A with the sheet name
Bookmarks