Sort date on descending from filter with vba

  • Hi all,

    I have this code here that I use to filter on a particular date. I will later on do this with a variable. in the column, there is also time in the cell "11/09/2017 09:33:39"
    How can I have this sorted?

    Worksheets("raw_data").Range("$A$1:$AW$56000").AutoFilter Field:=10, Operator:=xlFilterValues, Criteria2:=Array(2, "9/11/2017")


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!