Hi All,

Please help me adapt the following coding. I don't want to see sub totals in the pivot table( the coding works for that), but then I also don't want to see a blank item IF IT EXSISTS.

So I need to change the second part of the coding visible = false only if a blank item exists when the pivot table is recreated.

With ActiveSheet.PivotTables("PivotTable1").PivotFields ("LICENSING DIST NAME")
.Subtotals = Array(False, False, False, False, False, False, False, False, False, _
False, False, False)
' .PivotItems("(blank)").Visible = False
End With

Thanks a lot