Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Using Filters in Macros | Excel Discussion (Misc queries) | |||
Using Filters in Macros | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
macros, filters, HELP | Excel Programming |