• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to loop through slicer and select all but one item


New Member
I have a slice for project names that's from a data model. I'm trying to write a macro to first clear the slicer and then select all items except for one named "Headcount". I've tried some examples posted to forums but all of them result in a run time error.

Any suggestions out there?



Excel Ninja
Hi ,

Post links to those examples which have not worked , or post the code which does not work , or best of all upload your workbook with the data , the Data Model , Pivot Table(s) , Slicer(s) and code in it.