Is pivot table empty?

eurano · Apr 8th 2016

How to determine if pivot table is empty by using vba?

Grimes0332 · Apr 8th 2016

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.

eurano · Apr 11th 2016

Re: Is pivot table empty?

What kind of error should I get? My pivot is named "Tabela przestawna4" should I change the script with that name?

Participate now!