Related:
- Vba filter between two dates
- Vba case like - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Safe search filter - Guide
- Filter unknown senders - 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