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
