I tried what you suggested

Actually, you didn't (syntax problems). go back to the original post to see
a tested routine that does what you describe.

--
Regards,
Tom Ogilvy

"hme" wrote in message
...

--------------------------------------------------------------------------
------

DEAR TOM

I tried what you suggested as below mentioned but it does'nt work I
don't know why maybe because of the range is in arabic font.

set rng = cells.Find(What:="-BUSH-" , Lookat:xlWhole)

When I use Find("BUSH") to find a range in the cells in a worksheet,
macro find also "GEORGE BUSH" or "BUSHING".

How can I find just "BUSH" nothing more in the string.





Regards
HME


--
hme
------------------------------------------------------------------------
hme's Profile:
http://www.excelforum.com/member.php...o&userid=15930
View this thread: http://www.excelforum.com/showthread...hreadid=276984