Hi
I have a pivot table and a linked slicer which has dates as items. To cover a calendar year, the number of items is 365.
I also have a userform where FromDate and ToDate variables can be selected (via MSCalendar). On choosing the two dates, the following code enables the selected date items on the slicer.
However, the code seems to take ages to go through each slicer element via code.
Can someone figure out why it would be so slow?
Thanks
Please Login or Register to view this content.
Bookmarks