.Find Next

The 'lookat:=xlPart' is telling Excel that you are wanting partial matches as well.

"gate", "big gate", "really big gated drive", "segregated" will all match a search pattern of "gate", (and be careful of cases like the 3rd & 4th one's as they can really catch people out if you are searching for short strings in particular)

If you only wanted exact matches you would use 'lookat:=xlWhole', which would then only match the first case in the example above.

I don't know, but it's quite possible that 'Find' is case sensitive? Try searching for "Gate" and also "GATE" and see if you get different results?