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.