return row from find

[starl]

in vba - I'm doing a find in a range. How can I return the row in which the item is found?

thanks

 

[Barrie Davidson]

On 2002-10-24 16:56, starl wrote:
in vba - I'm doing a find in a range. How can I return the row in which the item is found?

thanks

Try something like this

Cells.Find(What:="item", After:=ActiveCell, LookAt:=xlPart, MatchCase:=False).Row

Regards,