Hide rows between 2 pivot tables if they are empty

Hello everyone,

I have 2 pivot tables: The first one starts in cell B12 and the second one starts in cell B30. If the page field selections are set to "ALL" in both tables there would be 4 rows between the first and second table. I have a form that allows the user to make a selection that would trigger the selections in both Pivot table. Whatever the selection is (except the "ALL" selection) the number of rows would increase (sometimes 8,10,15..it depends). Is it possible to write a macro that will conduct the number of empty rows between the 2 tables and hide them?? I can probably embed the code with the code behind the button that triggers both tables. Any ideas would be greatly appreciated.

Thank you
Richard

Suggest adding the following short code somwhere in your existing macro....

Please Login or Register  to view this content.

This assumes the 4 empty rows between the tables are rows 26,27,28, & 29 and tht these remain blank.

Thank you That helps