I have 30+ sheets with 1 pivot table and 3 slicers in each sheet.
In VBA, how do I delete all slicers in an activesheet (not all worksheets, just the activesheet)?
I have 30+ sheets with 1 pivot table and 3 slicers in each sheet.
In VBA, how do I delete all slicers in an activesheet (not all worksheets, just the activesheet)?
Try:
Sub foo() Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoSlicer Then shp.Delete Next shp End Sub
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
That worked perfectly. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks