How do I select Current PivotField??

[karl04]

Is there any way to find out what the current PivotField is (using VB)?
I need to set the Function property of the PivotTable to xlVarP

cheers

 

[karl04]

To answer my own question.....

You can use the following code to set the function of a Pivot Table where the top left-hand cell of the table is A3.

code: Range("A3").Select
ActiveCell.PivotField.Function = xlVarP



Replace xlVarP with whatever function you wish to use such as - xlSum, xlCount or xlAverages.