VBA autofilter on database from date in specific cell

Viewed 22

i am looking a VBA code to filter on a date : In Sheet1 in the cell N25 i have the start date and in Sheet2 i have the database. I would like to filter the database with the start date from the Sheet1

Please see my code that not working

Sub test_3()

Dim Date_start As Date

    With Worksheets("Sheet1")
        Date_start = CDate(Range("N25"))

   
    End With

    With Worksheets("Sheet2")
        With .Range("A1:AH" & .Cells(.Rows.Count, "A").End(xlUp).Row)
            .AutoFilter Field:=13, Criteria1:="=" & Date_start
  
    
    End With
    End With


End Sub

Thanks a lot for your help

0 Answers
Related