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.
|