Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in 2003 vs 2007
Hi,
I have the following macro that clears all filters in a pivot table of mine in 2007: Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs. When I try to run the macro in 2003 I get an error message that says: "Object doesn't support the property or method." Any ideas for how I can clear all filters in my pivot table in excel 2003 using a macro. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in 2003 vs 2007
Turn it on or off. That's all
Selection.AutoFilter Skinman "MichaelR" wrote in message ... Hi, I have the following macro that clears all filters in a pivot table of mine in 2007: Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs. When I try to run the macro in 2003 I get an error message that says: "Object doesn't support the property or method." Any ideas for how I can clear all filters in my pivot table in excel 2003 using a macro. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro in 2003 vs 2007
I believe that works for a table with filters but unfortunately not for a
pivot table. "Skinman" wrote: Turn it on or off. That's all Selection.AutoFilter Skinman "MichaelR" wrote in message ... Hi, I have the following macro that clears all filters in a pivot table of mine in 2007: Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs. When I try to run the macro in 2003 I get an error message that says: "Object doesn't support the property or method." Any ideas for how I can clear all filters in my pivot table in excel 2003 using a macro. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro from 2003 to 2007 | Excel Discussion (Misc queries) | |||
2003 Macro in a 2007 World | Excel Discussion (Misc queries) | |||
2003 to 2007 macro problem | Excel Worksheet Functions | |||
macro between 2003 and 2007 | Excel Discussion (Misc queries) | |||
Macro 2003 vs 2007 | Excel Worksheet Functions |