Hi Norm,
Excel's used range reflects the last cell that has been used since it was
last reset. Used includes formatting etc.
Probably better to use something like range("a65536").end(xlup) to find
the last nonblank cell in column A.
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
"Norm" wrote in message
...
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!!