Thread: Office 2003 pivot table filter clear
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Conrad[_2_] Conrad[_2_] is offline
external usenet poster
  
Posts: 3
Default 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 QuoteReply With Quote