VBA Return Slicer Selection

[wroze27]

I'm sorry if this exists somewhere, I cannot find an answer that works for me.

I am writing a program to save a sheet with a pivot table as a pdf. The pivot table has a slicer and I need to save a sheet for specific options in said slicer (only one selected at a time). I have the code to save as a pdf all ready, the only issue is that I would like to save the name of the pdf as the name of the slicer selection, but I cannot find out how to return the name or value of the selected slicer. Can anyone help me be able to return the value?

 

[Anthony47]

To capture the slicer selection you need to create a second "helper" pivot-table (PT) using a table that contains the slicer source list and filtering this second PT with the same slicer: at this point this second PT will show only the slicer selection. As illustrated by Chandoo here: Excel Slicers - Introduction, what are they, how to use them, tips, advanced concepts, interactive charts & reports using Slicers & Pivot Tables (search for "Capturing slicer selection using formulas")