I have an vb script that I run that formats several simular worksheets. One
of the things that is does is turns on the AutoFilter. I would like to have
it un-select one of the values on one of the columns during this format
process.

Example Data
a b
Row1 Ind Value
Row2 C 100
Row3 B 222
Row4 space 50
Row5 D 25
Row6 E 500

Both columns have the Filter On and I want to Un-Select all the values = "C"
in Column A

I know through recording a macro and looking at the code you can set a value
to a selection, but that only works if your selection is always in the same
position in the list. I do not have this option because some of my sheets
may have 2 options while others may have 20. To complicate things further
Value "C" may not even be in the list at all.

Thanks