ExcelBanter - Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivot Table (https://www.excelbanter.com/excel-programming/388965-pivot-table.html)

AA2e72E

Pivot Table

How do I delete an existing pivot table programatically?

Thanks.

MIKE215

Pivot Table

Try this

Sub RemovePivots()
For Each PT In ActiveSheet.PivotTables
PT.PivotSelect "", xlDataAndLabel, True
Selection.Clear
Next
End Sub

Regards,
Mike

"AA2e72E" wrote:

How do I delete an existing pivot table programatically?

Thanks.

AA2e72E

Pivot Table

Great stuff!
Thank you very much.

"MIKE215" wrote:

Try this

Sub RemovePivots()
For Each PT In ActiveSheet.PivotTables
PT.PivotSelect "", xlDataAndLabel, True
Selection.Clear
Next
End Sub

Regards,
Mike

"AA2e72E" wrote:

How do I delete an existing pivot table programatically?

Thanks.

All times are GMT +1. The time now is 01:16 AM.