VBA Excel 2000 - Pivot "Paste Special as Values"
Posted on 2011-02-15
In the daily work I am creating a lot of pivot tables, but typically needed only their numbers and not the pivot table itself with all of the wizard, formating etc functions.
So for this used to apply that selecting the pivot "arounding area", right click copy, after paste special as values. Can not do that copy on the pivot area itself and right click, because in Excel 2000 there is no copy option in the list.
Could you advise how to do it differently? Is there some command in VBA which would copy the pivot itself and paste special as values?