Finding The Rows Between Two Pivot Tables and Hiding

[mayoung]

I have two pivot tables on top of each other (Refer To Picture) that are created through VBA. The empty rows between the two pivots is always changing, based on the top pivots data changing, that is the reason for the gap between the pivot tables. Here is the tricky part . How can I select the empty rows between the two pivot tables and hide them. Leaving just two empty rows between them?

 

[Peter_SSs]

Assuming that your vba always creates that second PT at row 41, try this

With Range("A41", Range("A41").End(xlUp)).SpecialCells(xlBlanks)
  .Resize(.Rows.Count - 2).EntireRow.Hidden = True
End With

BTW,
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[mayoung]

Assuming that your vba always creates that second PT at row 41, try this

With Range("A41", Range("A41").End(xlUp)).SpecialCells(xlBlanks)
  .Resize(.Rows.Count - 2).EntireRow.Hidden = True
End With

BTW,
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Updated my account details thank you

 

[Peter_SSs]

Updated my account details

Did the code do what you want?

 

[mayoung]

Did the code do what you want?

Yes it worked very well. Thank You for it.

 

[Peter_SSs]

Cheers. Thanks for the confirmation.