--------------------------------------------------------------------------------
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