I'm trying to add a pivot table field using VB Office Tools (I have VB 2007
and Office 2007). In VBA, the command is
ActiveSheet.PivotTables("PivotTable1").AddDataFiel d
ActiveSheet.PivotTables("PivotTable1").PivotFields ("r3 Ret"), "r3 Ret ",
xlAverage

In VB, I can't figure out the equivalent constant for 'xlAverage'. I've
tried using Help but it doesn't describe this very well. What is the
equivalent of VBA's xlAverage in VB?