ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PivotTables.AddDataField (https://www.excelbanter.com/excel-programming/414388-pivottables-adddatafield.html)

Ed White[_2_]

PivotTables.AddDataField
 
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?




All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com