Posted to microsoft.public.excel.programming

Gary[_11_] Gary[_11_] is offline

external usenet poster

Posts: 7

Pivot Table Formatting

I wish to format subtotals in a pivot table using VBA. I know I can access all of the data from the "DataFields" property of a pivottable object, but how can I access the sub totals only

Thank you
Gary

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
2007 Excel Table and Pivot Table Formatting	sanmos	Excel Discussion (Misc queries)	0	February 9th 10 12:07 AM
pivot table formatting	mwam423	Excel Discussion (Misc queries)	1	July 18th 08 06:41 PM
Pivot Table Formatting	rciolkosz	Excel Discussion (Misc queries)	1	May 9th 08 12:39 AM
Pivot table formatting	David Ruderman - Chapman University	Excel Discussion (Misc queries)	3	March 7th 06 12:01 AM
Pivot Table border formatting and pivot chart formatting	[email protected]	Excel Discussion (Misc queries)	0	July 22nd 05 02:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us