Hi everyone!
I'm using EXCEL 97 and have the foll code:
Dim Thisitem as Pivotitem
Dim Pvtitem as String
With MypivotTable
For Thisitem in .pivotfields("FY").pivotitems
If Thisitem.Recordcount > 0 then
Pvtitem = Thisitem.name
Exitfor
Endif
Next
End with
The pivottable is sorted. Whenever the last item was < current item it is still remembered even when not showing up in the table. Is there a way to flush all the old items from memory?
Appreciate your help,
Jamuna
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only