Hi all,

I'm trying to automate a PivotTable to select the latest month available.
I can very easily select the latest month. My problem is in deselecting all other months/All/Blanks.

When using below, hiding “(All)” causes a debug (as it doesn’t allow nothing to be displayed).

How can I get around this?

Please Login or Register  to view this content.
Thanks for any help