Try setting the Lookin value to xlPart in the Find statement.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"emil" wrote in message
...
I have a word in a Cell. I copy it in " Find". I Search in another Sheet
that
word. If I have extra spaces before or after it I can not find it often it
exists. The word changed. I tried to write a macro but it doesn't work.
Can
helps me someone?
Thanks millions.
Emil