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


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

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

Regards
HME


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