VBA shortcut to control Pivot Table

[LB79]

Hi all,

Please can someone tell me if there is a way to uncheck all items in a pivot table row label selection without listing each item (There are a lot of items).
Ive been using the below code to remove my blanks from my reports but I need now to uncheck everything (then check on a single item).
Hope that makes sense

Thanks

Please Login or Register  to view this content.

[Andy Pope]

You have to loop through the items.
http://www.contextures.com/xlPivot03.html#ShowItem

this will display only (blank) item. There is not error trapping to handle all items being made invisible, see example in above link for more info

Please Login or Register  to view this content.