It's fine when I try it (Excel 2003).

I notice that you haven't copy/pasted EXACTLY what you have in your VBA
environment (for instance, there is no space after the comma before
"SearchOrder"), so I can't run your precise code. However, I did copy the
two statements out of the e-mail and into the VBE and they worked fine.

Before looking for other causes, you should suspect that it's something that
you are doing wrong. Things to look for would be double spaces in your
cells and a missing final space in the sTextToFind constant.

You might like to do an exact copy/paste of a few cells and of the code.