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

Range Filtering
 

maybe because you didn't try what I said:

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

Sub Tester3()
Dim rng As Range
Set rng = Cells.Find(WHAT:="-BUSH-", LOOKAT:=xlWhole)
If Not rng Is Nothing Then
rng.Select
End If
End Sub

worked fine for me.

--
Regards,
Tom Ogilvy

"hme" wrote in message
...

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


Regards
HME


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