On 17 dic 2007, 17:34, "Bill Renaud"
wrote:
<<If I could send you my excel file you could see better what I'm doing.

If you send me a file, please save it in Excel 2000 version, as that is the
version I am using, otherwise I may not be able to open it. Also, if the
file is large, then perhaps you could create a much smaller version to
send.

<<Replace 5 doesn't loop forever because there is an error when Find
doesn't find a proper cell.

Relying on an error to terminate a routine is BAD programming practice!
--
Regards,
Bill Renaud
Remove the No.Spam part of my e-mail address.
Leave only one period between the first and last names.

Now I can see, you are right. It was a problem with my country
options. VBA can't manage with spanish numbers with comma. I must
substitute comma with points before proceed.

Thanks a lot, you are a genious of programming. Merry christmas Bill.