Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
.AddDataField: is there a similar "replace" data field? | Excel Programming | |||
New to Pivottables- need help | Charts and Charting in Excel | |||
PivotTable: AddDataField method | Excel Programming |