The usual way to locate or find data in a range is to loop through a range applying logic to stop if a criteria is met.

Using the find method may be a quicker and more efficient way to locate data when searching a worksheet using VBA.

While there isn’t an abundance of information on using the find method with VBA, I did stumble upon this great tutorial:

Link:
The Code Net – The Ultimate Search