View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sorin sorin is offline
external usenet poster
 
Posts: 6
Default Delete PivotCache

Hi all,

I'd like to create a macro to easily delete a Pivot table.

I noticed that ws.PivotTables(i).TableRange2.Clear eliminates the
pivottable from worksheet and collection while pivotchache object still
remains in the workbook.

Any ideas?

Best regards