Hello All,

Thank you for your help in the past. I'm here with another question.

I need code to get the grand total of the row totals in a pivot table. Using
this grand total, I would need to delete the sheet (each sheet has only one
pivot table) if the grand total is zero.

I don't know what the name of the pivot table is, but I know for sure each
sheet that the macro is run on will have only one pivot table. Each pivot
table does have a row and column titled "Grand Total" and the grand total
that I need is the summation of the totals of each individual row. The pivot
table does have this data displayed on most bottom right.

Any help would be greatly appreciated.

-Karim