Hi

I need to be able to select in a worksheet all occurances of a user-
specified value (examples - select all zeros; select all values = "test").
The ability to specify exact match or contains would be useful.
Can someone point me in the right direction.



--
Stephen

?B?SkJlYXVjYWlyZQ==?=
wrote in :

I would turn on AutoFilter, then in the column in question use the
drop down arrow and select CUSTOM.



That would work in one row, I need it to work across a whole worksheet or
selected range.

--
Steve

Due to the volume of garbage I filter out googlegroups. So do many others.
Gmail posters are currently scored down pending troll filter work.

I would turn on AutoFilter, then in the column in question use the drop down
arrow and select CUSTOM.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Cawshus" wrote:

Hi

I need to be able to select in a worksheet all occurances of a user-
specified value (examples - select all zeros; select all values = "test").
The ability to specify exact match or contains would be useful.
Can someone point me in the right direction.



--
Stephen