I use VBA for filter Date in excel as below.
MsgBox show 31/05/2021Sub FilterDate (Date2 as String)
Sheets("Cash").Select
MsgBox (Date2)
Range("E1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$J$373").AutoFilter Field:=5, Criteria1:= _
"<"& Date2 , Operator:=xlAnd
End Sub
But output after filter show blank.
Capture.JPG
Please guide me for solve it.
Bookmarks