VB Code for date filtering

[JOMS1]

Hi,
I wanted to filter column C with a condition that the date in C is greater than a date availabale in cell N1
Can anyone help me with the VB code for this
Thanks and Regards

 

[Trevor_S]

Dates can always be tricky due to formats - but the following works if the dates are in the format dd/mm/yyyy:

Sub Macro1()


    Dim myCriteria As String
    myCriteria = ">" & Range("N1").Value
    Range("C:C").AutoFilter Field:=1, Criteria1:=myCriteria
    
End Sub

 

[JOMS1]

thank you so much
it worked