"crew3407 " schrieb im Newsbeitrag
...
Hello,

Quick question, I was just wondering how you find the row index of a
cell that i found using find and then storing that into a variable. I
need to reference information in that row. Thanks


---
Message posted from http://www.ExcelForum.com/


the find method results in a range object.

set myresult = .find(.....)

You can assign myresult.row then to your variable.

cheers,
Stephan