Reset AutoFilter in code
Option Explicit
Sub SetAutoFilter()
Dim target As Range
Set target = Range("A1:C1")
FilterA target
'turn filter OFF
target.AutoFilter
'TURN FILTER ON
target.AutoFilter
End Sub
Sub FilterA(target As Range)
' turns filter ON with a filter
target.AutoFilter Field:=1, Criteria1:="=*1", Operator:=xlAnd
End Sub
"Brian Bermingham" wrote in
message ...
Hi
I know how to remove AutoFilter.
Worksheets("Absence").AutoFilterMode = False
But how can I leave the autofilter in place just removing any applied
filter?
Some thing like AutoFilter.reset !
Thanks
Brian
|