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 "-BUSH-ING".

How can I find just "-BUSH-" nothing more in the string.

Regards
HME

 

[Tom Ogilvy]

set rng = cells.Find(What:="-BUSH-",Lookat:=xlWhole)