ExcelBanter - Range Filtering

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Range Filtering (https://www.excelbanter.com/excel-programming/316303-range-filtering.html)

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

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