Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: VBA for Pivot Table Subtotals

  1. #1
    Board Regular
    Join Date
    Jan 2010
    Posts
    221
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA for Pivot Table Subtotals

    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

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,132
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VBA for Pivot Table Subtotals

    You can put the code you got when you recorded the macro.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •