uktous
10-20-2012, 08:26 AM
Hi ,
I recorded the macro below.
The macro can create a filter and show all data after 15 Oct 2012.
When I record it, correct result can be shown.
However, when I used the same macro after I removed the filter, no data can be shown.
I checked the filter.
The filter has correct criteria.
I used the same criteria for the filter, then correct result can be shown.
Could you please amend the macro so that only data after 15 Oct 2012 will be shown.
Sub Macro8()
ActiveSheet.Range("$A$1:$E$2493").AutoFilter Field:=1, Criteria1:= _
">15/10/2012", Operator:=xlAnd
End Sub
thanks
I recorded the macro below.
The macro can create a filter and show all data after 15 Oct 2012.
When I record it, correct result can be shown.
However, when I used the same macro after I removed the filter, no data can be shown.
I checked the filter.
The filter has correct criteria.
I used the same criteria for the filter, then correct result can be shown.
Could you please amend the macro so that only data after 15 Oct 2012 will be shown.
Sub Macro8()
ActiveSheet.Range("$A$1:$E$2493").AutoFilter Field:=1, Criteria1:= _
">15/10/2012", Operator:=xlAnd
End Sub
thanks