Hello, I have a problem because I have a macro set to group items in a PivotTable always in the same range every month. The problem is that he needs to hide a certain group every month and a different one every month. Eg pmf_Wint_m36 in July and m37 in August and so on. I always need to hide the last but one option selected. My code is below : wb.Sheets("analysis-tabele").Activate wb.Sheets("analysis-tabele").Range("A4:A5").Select Selection.Group ActiveSheet.PivotTables("pivot5").PivotFields("pmf_VINT_M36"). _ '''<---------- I would like PivotFields of pmf_VINT_M36 there was a code ticking off the penultimate option ''' wb.Sheets("analysis-tabele").Range("B4:N19").Copy Destination:=wb.Sheets("analysis-tabele").Range("B21")

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA group pivot table problem with hidden group

Thread starter Palucci
Start date Sep 27, 2021

Palucci

Banned user

Sep 27, 2021

Hello,

I have a problem because I have a macro set to group items in a PivotTable always in the same range every month. The problem is that he needs to hide a certain group every month and a different one every month. Eg pmf_Wint_m36 in July and m37 in August and so on. I always need to hide the last but one option selected.

My code is below :

Rich (BB code):

wb.Sheets("analysis-tabele").Activate
wb.Sheets("analysis-tabele").Range("A4:A5").Select
    Selection.Group
    ActiveSheet.PivotTables("pivot5").PivotFields("pmf_VINT_M36"). _  '''<----------
I would like PivotFields 
          of pmf_VINT_M36 there was a code ticking off the penultimate option '''
wb.Sheets("analysis-tabele").Range("B4:N19").Copy Destination:=wb.Sheets("analysis-tabele").Range("B21")