Post some sample data with several that do contain "test"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"h2fcell" wrote in message
...
Hello,
Im looking for a way to select all cells in a current region with a
certain
value.
Similar to what Go To Special does with blanks or constants.
Selection.SpecialCells(xlCellTypeConstants, 23).Select
Id like to avoid using loops or If then, because the region is quite
large
and there are few cells that meet the condition.
The value is the word €œtest€�.
Is there a way to use Selection.SpecialCells for cells containing the word
test?
After all the cells containing the word test are selected, Ill change the
selections format.