Hi,
I would like to amend this code so that the criteria2 references to a date in cell A2 Sheet1 (which would contain date 12/1/2023).
How would I do that?
Thanks,
N.
I would like to amend this code so that the criteria2 references to a date in cell A2 Sheet1 (which would contain date 12/1/2023).
VBA Code:
Option Compare Text
Sub test()
With Range("A3:d" & Cells(Rows.Count, "A").End(xlUp).Row)
k = .Find("DATE", lookat:=xlWhole).Column
.AutoFilter k, Criteria1:=">=7/1/2023", Operator:=xlAnd, Criteria2:="<12/1/2023"
End With
End Sub
How would I do that?
Thanks,
N.