Is pivot table empty?

  • Re: Is pivot table empty?


    Check the item count for a named field.


    Code
    PivotTables(1).PivotFields("FieldName").PivotItems.Count



    You will need error handling as an error will be thrown if none.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!