filters and macros
Hello,
I do have a spreadsheet, where I do have created auto filter.
When I manually set the custom autofilter logic, the correct data will be
filtered.
Now I recorded a macro, which sets the autofilter, copys some subtotal
results and then sets some other filters, where it does the same.
=============
Macro
=============
Selection.AutoFilter Field:=13, Criteria1:="0,5", Operator:=xlAnd, _
Criteria2:="<=1"
Range("T1").Select
Application.CutCopyMode = False
Selection.Copy
Range("AP2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("U1").Select
Application.CutCopyMode = False
Selection.Copy
Range("AP3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
==================
When I now run the filter, no rows will be selected.
If I go into debug mode and set a breck point after the first cut function,
I can see that the filter was set by the macro, but not activated.
Any idear what when wrong in the recording?
|