Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,261
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.
Read more about this 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...
Read more about this Excel article...