Posted to microsoft.public.excel.programming

Conrad[_2_] Conrad[_2_] is offline

external usenet poster

Posts: 3

Office 2003 pivot table filter clear

Yee haaa I outta kick my own ass
Im da Lord of Excel. Wooptie do

IF anyone needs da code Here it i
Dim i As Intege

For i = Worksheets("WorkSheet1").PivotTables("PivotTable1" ).PivotFields("WhaEva").PivotItems.Count To 1 Step -
Worksheets("WorkSheet1").PivotTables("PivotTable1" ).PivotFields("WhaEva").PivotItems(i).Delet
Next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Clear a Pivot Table Cache	DoctorG	Excel Discussion (Misc queries)	1	February 16th 10 03:04 PM
2003 Pivot Table Filter (items dropped in the Page Fields)	SeanF74	Excel Discussion (Misc queries)	1	October 15th 09 04:49 PM
Pivot Table Clear All Fiels	MichaelR	Excel Discussion (Misc queries)	3	July 3rd 08 04:49 PM
Office 2003 pivot table filter data values	maggiethomas	Excel Discussion (Misc queries)	0	June 12th 08 01:32 PM
Pivot Table formatting in office 2003	Douglas O''Neill	Excel Discussion (Misc queries)	2	January 7th 06 12:05 AM

All times are GMT +1. The time now is 04:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us