Hi all,

Does anyone know how I can read with vba the selected items in the report filter of a pivot table?

I use this to read when there is only one item:
Please Login or Register  to view this content.
and it works.

But I am confused with the multiple selected items, and google didnt help much. I used the below code with no success. I get a Subscript out of range error in the EnableMultiplePageItems line. I also used a variation reading the items but doesnt work either:

Please Login or Register  to view this content.
Can anyone help?

Thanks a lot in advance!


Please Login or Register  to view this content.