VBA for Pivot Table Subtotals

storm925

Board Regular
Joined
Jan 20, 2010
Messages
226
Hi All,

Wanted to know if anyone can help me with the following VBA for a pivot table, which is not working...

Code:
With ActiveSheet.PivotTables("PivotTable1").PivotFields("ACCT_DESC").Subtotals
     .Font.Bold = True
End With
I'm trying to avoid using ".PivotSelect", which is what you get when you record. Thank you for reading my post and any help would be greatly appreciated. --Ben
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,170
Office Version
2007
Platform
Windows
You can put the code you got when you recorded the macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,713
Messages
5,446,102
Members
405,379
Latest member
EDGOUG

This Week's Hot Topics

Top