Keith, using your example, how do I select the row that it finds th
value in?
For example using:

Set fr = Searchrange.Find("GUHX01HP03", LookIn:=xlValues)

will just give me that cell value whereas I need the entire row so
can edit bits on it.

Any ideas?

Thanks again

And

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