Filter date in macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i set up a macro below to filter out a column (dates) that are more than
cell F2, where cell F2 is also a date. But it just doesn't work. Why? Thanks!

Sub Filter_BS()

Selection.AutoFilter Field:=7, Criteria1:=">" & Range("f2"),
Operator:=xlAnd

End Sub

Val
 
I'd try:

Selection.AutoFilter Field:=7, _
Criteria1:=">" & format(Range("f2").value,"mm/dd/yyyy")

But match the numberformat of the dates in that field.
 
Back
Top