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

DEAR TO

I tried what you suggested as below mentioned but it does'nt work
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
HM

--
hm
-----------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...fo&userid=1593
View this thread: http://www.excelforum.com/showthread.php?threadid=27698