Slicer selecting deselcting

[cogswel__cogs]

I have a slicer called Rep

I would like to walk through seletions on rep with vba.
The list is not the full list in pivot field/slicer as I am only running for some of the reps.

So I can set for first and plan to PDF screen
deselect that rep in slicer
select new rep in slicer
make sure all pivots are updated
pdf screen again.

I have already coded the pdf part just need to now how to select /unselect in a slicer.
And how to make sure it has updated all its associated pivots before pdfing again.

All help is greatly appreciated.

 

[cogswel__cogs]

Resolved this using one of the pivot tables to select and deselect in.
Still would love to know if I could have done in slicer.