Forum Discussion

Copper Contributor

Oct 24, 2021

Expand Excel PivotTable without overlaying another PivotTable (VBA)

Hi guys, please help me. I need to expand my Excel pivot table without overwriting the other pivot table below. Is it possible to do this using VBA? Would anyone have the code? I need that when I cli...

excel

Formulas and Functions

Macros and VBA

Rai__LS

Copper Contributor

Nov 13, 2021

Yah, i know that, is because of that i need do it using a VBA code. I´m looking for this code in the web.

Yea_So

Bronze Contributor

Nov 14, 2021

you don't need VBA to find that place, that place is to the left of the location of the pivot table will not be affected by the expansion/contraction of the pivot table.