I have defined my range as the following:
Dim RNG As Range
Set RNG = Range("A2", Range("A65536").End(xlUp))
RNG.select 'for testing to see what cells are in the range
The above sets the range as A2 to A117. I now want to remove the last 2 rows from this range, so that I have A2:A115 (I can not make this a static range as the data will likely change).
Attached is an example (hand typed, not a pivot table) where I would want to set RNG = A2:A11.
Or - is there a method to call A2:A11 (everything underneath PLAN, in my example) via a pivot table property?