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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks