![]() |
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