• 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

    Hui...

  • 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

morgyt

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?

Thanks~
 

NARAYANK991

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.

Narayan
 
Top