I'm sure by now everybody is tired of me and my questions, but this one I'm sure is simple and quick, but I've been unable to find exactly the answer in searches of this forum and others.

How can I search a particular column of cells for a certain value and get the row number of where that value is?

i.e. search column B for a cell with "apple" in it, and get the row of where it is.

I'm thinking worksheetfunction.find, maybe? Although I don't know how to use that, and I'm not sure that's what I need.