Posted to microsoft.public.excel.programming

Ed White[_2_] Ed White[_2_] is offline

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTables	Gerry Verschuuren	Excel Discussion (Misc queries)	4	October 25th 07 01:12 AM
PivotTables	KerryK	Excel Discussion (Misc queries)	2	October 8th 07 07:06 PM
.AddDataField: is there a similar "replace" data field?	PW	Excel Programming	0	November 22nd 05 11:53 PM
New to Pivottables- need help	coal_miner	Charts and Charting in Excel	1	June 6th 05 06:48 PM
PivotTable: AddDataField method	Tony G	Excel Programming	0	July 16th 03 01:43 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us