W
webels
Hi
Below is part of a Macro to Autofilter by a date in cell "N1".
Range("N1").Select
Selection.NumberFormat = "dd/mm/yyyy;@"
Columns("A:A").Select
Selection.NumberFormat = "dd/mm/yyyy;@"
Range("A2").AutoFilter Field:=1, Criteria1:="<" & Range("n1"),
Operator:=xlAnd
I formatted the values in N1 and column A to be the same date format
to hopefully avoid problems, however the filter does not work.
Dates like 13/07/2010 and 12/07/2010 get formatted to
13/07/10 and 07/12/2010 respectively (both should be filtered out
as the date in N1 is greater than both dates however only the
07/12/2010 gets filtered)
Is there another way to format these dates to make my filter work.
Much appreciated
Eddie
Below is part of a Macro to Autofilter by a date in cell "N1".
Range("N1").Select
Selection.NumberFormat = "dd/mm/yyyy;@"
Columns("A:A").Select
Selection.NumberFormat = "dd/mm/yyyy;@"
Range("A2").AutoFilter Field:=1, Criteria1:="<" & Range("n1"),
Operator:=xlAnd
I formatted the values in N1 and column A to be the same date format
to hopefully avoid problems, however the filter does not work.
Dates like 13/07/2010 and 12/07/2010 get formatted to
13/07/10 and 07/12/2010 respectively (both should be filtered out
as the date in N1 is greater than both dates however only the
07/12/2010 gets filtered)
Is there another way to format these dates to make my filter work.
Much appreciated
Eddie