Related:
- Excel vba filter data between two dates using userform
- Number to words in excel without vba - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Enable vba in excel - Guide
- Vba code to search data in excel - Guide
- Excel date format dd.mm.yyyy - Guide
1 response
in case of date store the range of date in variables fromdate and todate. Input values in Variables whether through excel cell or inputmsg or hard code it. Try this code
ActiveSheet.Range("$B$5:$O$289").AutoFilter Field:=2, Criteria1:= _
">=" & fromdate, Operator:=xlAnd, Criteria2:="<=" & todate
hope this works
ActiveSheet.Range("$B$5:$O$289").AutoFilter Field:=2, Criteria1:= _
">=" & fromdate, Operator:=xlAnd, Criteria2:="<=" & todate
hope this works
