Thread: Range Filtering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hme hme is offline
external usenet poster
 
Posts: 1
Default Range Filtering


Hi


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.


I tried what dear *Tom Ogilvy * suggested as below mentioned but i
does'nt work I don't know why maybe because of the range is in arabi
font.

SET RNG = CELLS.FIND(WHAT:=\"-BUSH-\" , LOOKAT:XLWHOLE


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