Pivot Table Formatting

G

Gary

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Pivot Tables - using .AutoShow 1
Change report firlds in pivot tables and charts with one selection 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Consolidation Table from Different Excel Tabs with Different Format 1
Power Pivot. Yikes. 0
Changing pivot table ADO recordset 0

Top