PDA

View Full Version : Slicers:Extract selected & unselected items to a Range



aravindhan_3
01-11-2016, 04:32 AM
Hi,

I have salary pivot table and have Geography as a Slicers ( about 20 Geos) is there a way in VBA to extract all selected items from a Slicers as a separate list to Column H, & unselected items to column I

thanks for your help in advance

Regards
Arvind