Advance Filter
On Jun 25, 5:15*am, "fi.or.jp.de" wrote:
Hi All,
I have excel file. I am doing some filtering.
in Column A i have more than 1000 rows, with more than 100 unique
values.
I want to deselect some of the values, say 4 items. In excel i can do
it only two item with available option.
In VBA i got few codes which select the more than two item in the
filter.
here's my code
Dim Sht As Worksheet
Dim Crt(0 To 2) As String
Set Sht = ActiveSheet
Crt(0) = "A"
Crt(1) = "B"
Crt(2) = "C"
Sht.UsedRange.AutoFilter Field:=1, Criteria1:=Crt,
Operator:=xlFilterValues
The above code filters only "A", "B" & "C" values.....
My question : is there any option to deselect only "A", "B",
"C"....???
???
<
|