Partial Strings Match

This code is not case sensitive.
jagadeesh will match jagadeesh rt or Jagadeesh rt.
If you want it to be case sensitive then change this line.

If InStr(1, x.Value, r.Value, 1) > 0 Then

to this

If InStr(1, x.Value, r.Value) > 0 Then

Good Luck.


If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.