Expand Collapse Side by side Pivot tables

[Mjk7239]

All,
Looking for VBA code to expand / collapse multiple pivots when selecting an item in the first pivot table.

Any help on this would be greatly appreciated.
Thank you in advance.
Mark

 

[mole999]

leave ten or fifteen columns between, and hide them. close to and often you get a failure. code to do what you want I don't know

 

[Mjk7239]

Thanks, but you're not close, these are two separate Pivot tables with about 20 columns between them so they don't run into each other.

I have slicers that are connected to each so that they slice and dice simultaneously but to expand and collapse simultaneously is another issue.