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?