I see that,
I have and specific question, How can I put into my code the "empty
value, because this statement works, but only when the cells have th
specific value, and know, I think it shuld be works on the first cel
that doesn't have the value.
Code
-------------------
Sub Busqueda()
Sheets("hola").Columns(2).Find _
(What:="hola", After:=[B1]).Replace _
What:="hola", Replacement:="Richard"
End Sub
-------------------
thnks for ur fruitfull help
Davi
--
Message posted from
http://www.ExcelForum.com