Excel VBA Code Date Filter between two dates Closed

Question

I want to filter data between "15 apr 2010" and "26 apr 2010" . All Dates are stored in column B.  The below code is generated by excel macro recorder but despite having dates between the specified range nothing is showing when I run the macro. Dates are stored in "dd/mm/yyyy" format
Please help me.

Thanx
 
ActiveSheet.Range("$B$5:$O$289").AutoFilter Field:=2, Criteria1:= _
        ">=15/04/2010", Operator:=xlAnd, Criteria2:="<=26/04/2010"

Basit · Accepted Answer

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

Excel VBA Code Date Filter between two dates

1 response

Similar discussions

Subscribe To Our Newsletter!