If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA: Finding selected slicer items without a loop

Thread starter Worf
Start date Jun 7, 2020

Overview Discussion

Worf

Well-known Member

Jun 7, 2020

Worf submitted a new Excel article:

VBA: Finding selected slicer items without a loop - Shows how to avoid looping all items to determine the selected ones.

Sometimes you have slicers with a long list of items, and need to find out what are the selected items. Normally, it is necessary to loop through all items to get this information, as shown on the first code.

However, if the pivot table is created with the Data Model option checked, it will be OLAP based thus allowing the second method, which loops only the array containing the desired slicer items. If no item is selected it will inform that all are displayed.

Note that this kind of pivot...