VBA Macro to unfilter specific column

[Tony D]

Hello - would like to know VBA code to unfilter a specific column but leave any other columns with filters active intact.

So for example if a filter is on Column A & C, but want to clear filter in Column B, how to do it without filters changing currently on A & C.

Thanks very much in advance!

 

[Claus Busch]

Hi Tony,

Am Mon, 19 Aug 2013 11:14:21 -0700 (PDT) schrieb Tony D:

Hello - would like to know VBA code to unfilter a specific column but leave any other columns with filters active intact.

So for example if a filter is on Column A & C, but want to clear filter in Column B, how to do it without filters changing currently on A & C.

you can filter one column or coherent columns but not incoherent columns
say you can't filter A and C, but you can set the filter for column B
for all values and hide the dropdown button:

With ActiveSheet.UsedRange
.Range("A1:C" & .Rows.Count) _
.AutoFilter field:=2, Criteria1:="<>", _
visibledropdown:=False
End With


Regards
Claus B.