Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SpecialCells and UsedRange
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specialcells | Charts and Charting in Excel | |||
SpecialCells(xlCellTypeFormulas) | Excel Programming | |||
AutoFilter /specialcells | Excel Programming | |||
specialcells(xlcelltypeblanks) | Excel Programming | |||
Usedrange | Excel Programming |