VBA Code to Dynamic ranging of Pivot and Slicer selection

[PramodNair]

I have made a macro which gives Dynamic Ranging of Excel pivots using same data source
But after using macro when I am trying to select the connection of pivot in Slicers I am not able to see both Pivot tables in the Slicer Connection

Can anybody help me to resolve this without using the Offset formula in Named function i.e by only using macro it should be resolved

 

[Awesome Wally]

I had this very same issue last week. I reached out to Jeffery Weir after reviewing some techniques he recommended for someone else. http://stackoverflow.com/questions/...ng-for-improvements-to-code/39604425#39604425
http://stackoverflow.com/questions/...p-down-selections-using-vba/39111413#39111413

Jeffery subsequently provided me an awesome work around using VBA. See the attached Sample file the he sent me.