Using VBA to hide any rows that sit below a pivot table

[danijacques]

Hello,

I have setup a Vlookup next to a pivot table to display data that cannot sit within the pivot table.
This Vlookup references the pivot table rows, and returns data accordingly.
However the pivot is linked up to slicers, which obviously affects the amount of cells that the table occupies.

Accordingly I am trying to setup VBA that references the pivot table, and hides any cells below it so that for aesthetic purposes the Vlookup does not extend beyond the pivot table.

Does anyone have any ideas on how to do this? Or if there happens to be any better ways I haven't thought of.

Thanks in advance for your help.

Dani