hello
I have this code but I would make autofilter mode = false after filter data I tried with this code but it doesn't so far
any idea to do that ,please ?
I have this code but I would make autofilter mode = false after filter data I tried with this code but it doesn't so far
any idea to do that ,please ?
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
If Range("B2") = "All" Then
Range("A3:E3").AutoFilter
Else
Range("A3:E3").AutoFilter Field:=2, Criteria1:=Range("B1")
'ActiveSheet.AutoFilterMode = False
End If
End If