I'm trying to figure out how to filter by the year only in a column where I have dates specified as dd/mm/year.
This is being done through VBA and I tried the following (relevant code posted), but it doesn't seem to be working:
Any suggestions or help is appreciated.![]()
d_year = ComboBox2.Value If Not d_year = "" Then d_year = "*" & d_year & "*" With .Range("A1:K1") .AutoFilter field:=6, Criteria1:=d_year End With End If
Bookmarks