Mantain Fixed Pivot Table Data Range

[Sharkz00ka]

Hi everyone,

I have a macro that deletes rows from a set of pasted data. My problem is that I have a pivot pointing at that data. When I paste my extraction and delete the columns, the data range of the pivot reduces (for example from A:AA to A:W).

Is there a way to keep a fixed range, even if I delete columns? (the pivot data range points to the correct columns post deletion)

 

[SpillerBD]

no.
The order in which the data is copied is fouling it up. If there are columns or rows to be deleted, that should be done before it is copied to the range where your pivot table runs.
However, that is exactly what Get & Transform does for users in Excel2016