Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Programming | Excel Programming | |||
Excel vba pivot table programming | Excel Programming | |||
Pivot Table Programming | Excel Programming | |||
Pivot Table Programming | Excel Programming | |||
Pivot table Programming | Excel Programming |