Thread
:
Delete pivot table
View Single Post
#
1
Posted to microsoft.public.excel.programming
HSalim[MVP]
external usenet poster
Posts: 70
Delete pivot table
Hi
What is the syntax to delete a pivottable programatically? I tried
Dim ws As Worksheet
Dim pt As PivotTable
Set ws = ActiveWorkbook.Worksheets("unused")
Set pt = ws.PivotTables(1)
pt.Delete ' error
Set pt = Nothing
Thanks
Habib
Reply With Quote
HSalim[MVP]
View Public Profile
Find all posts by HSalim[MVP]