Range Filtering

[hme]

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

 

[Tom Ogilvy]

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.