I’m trying to find my last row in a PivotTable which can be filtered and hence changes in row size.
The below code does not find the last row.
However, the code works if I manually set the lastRow = 9.