The find method will generally be quicker - how much quicker depends on the number of cells that your are searching. A couple? Or millions?

As a first principle, I try to rely on built in features rather than looping code when dealing with cells: sorting, filtering, finding, removing duplicates, using formulas in a block, etc. There are a lot of good things hidden within Excel

I looked at your other posts and have nothing to offer... sorry.