I am looking to pdf each pivot table item (compound) based on a criteria (max(cell range) greater than 0

ignore the vendor stuff, this code is pulled from the internets.

Please Login or Register  to view this content.
The cell c5 contains the formula =MAX(B11:AQ90) (the maximum size of my pivot table) I think I am missing something, like update cell or calculate cell value, but with out the If Then statement, I print out all 200 tables and i only want the ones with data (max > 0)

Thanks in advance!