I am using a pivot table that starts on row 5. A macro
needs to know the bottom row of the pivot table, so I used
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row.

I'm finding a problem when we filter the pivot table - say
from 2000 rows to 10 rows - the SpecialCells variable
still gives 2000 rows. But if I access UsedRange, then
SpecialCells gets updated to the correct value of 10.

Any ideas why SpecialCells(xlCellTypeLastCell) does not
update correctly?

Thanks!!