{"id":116,"date":"2011-03-20T15:41:39","date_gmt":"2011-03-20T14:41:39","guid":{"rendered":"http:\/\/mariaevert.dk\/vba\/?p=116"},"modified":"2011-03-20T15:43:30","modified_gmt":"2011-03-20T14:43:30","slug":"vba-delete-pivottables","status":"publish","type":"post","link":"https:\/\/mariaevert.dk\/vba\/?p=116","title":{"rendered":"VBA &#8211; Delete PivotTables"},"content":{"rendered":"<p>This code snippet shows how to loop through all pivot tables in all worksheets and delete them: <\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\n\r\nSub DeletePivotTables()\r\n\r\n    Dim Pt As PivotTable\r\n    Dim Ws As Worksheet\r\n    \r\n'Loop through worksheets \r\n    For Each Ws In ActiveWorkbook.Worksheets\r\n    Worksheets(Ws.Name).Select\r\n\r\n'Loop through pivot tables         \r\n    For Each Pt In Ws.PivotTables\r\n           \r\n'Delete pivot table\r\n           Pt.PivotSelect &quot;&quot;, xlDataAndLabel, True\r\n    Selection.Delete Shift:=xlToLeft\r\n\r\n            'Exit Sub 'Optional: Get out\r\n        Next Pt\r\n    Next Ws\r\nEnd Sub  \r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This code snippet shows how to loop through all pivot tables in all worksheets and delete them:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,5],"tags":[],"_links":{"self":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/116"}],"collection":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=116"}],"version-history":[{"count":5,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":120,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions\/120"}],"wp:attachment":[{"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mariaevert.dk\/vba\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}