Pivot table programming
 

I have a line of code that grabs the totals lines from a pivot table and
formats them. However, if there is no data in a pivot tables, this line
errors out.

Is there a way to block this line if there is no data on a pivot table?

Pivot table programming
 

Without seeing your code it's hard to come up with an exact solution,
however try getting the pivot items count and verify that it is 0,
something like this:
ActiveSheet.PivotTables("PivotTable1").PivotFields (1).PivotItems.Count

Charles

havocdragon wrote:
I have a line of code that grabs the totals lines from a pivot table and
formats them. However, if there is no data in a pivot tables, this line
errors out.

Is there a way to block this line if there is no data on a pivot table?