Your code
.PivotFields("FieldName").PivotItems("(blank)").Visible = False
will not select blanks field in pivot table.
what I am trying to do is select everything, but not select blanks and 0.
How do I do that, I can put a code to say select this, this this, this, but it will not be good written code
because there are 30, 40, or 50 items and the code will be long and I sometimes don't know what items
there are since when the pivot table gets refresh there are new items.
I just know that I need to unselect Zeros and blanks but show everything else.
Thanks