Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So I have written up some code in VBA that basically takes some sloppy input
files (system reports) and formats them, adds in some new fields for more info and creates pivot tables. In each of the pivot tables year is the column field. My original problem was that "blank" would appear in this field. That was easily fixed by adding this to the code of each table creation: With ActiveChart.PivotLayout.PivotTable.PivotFields("Ye ar") ..PivotItems("(blank)").Visible = False End With Now the only problem with my fix is that if "blank" is not in the field it will error out. Is there something similar to the below that will only make blank visible = false if blank exists? With ActiveChart.PivotLayout.PivotTable.PivotFields("Ye ar") If .PivotItems("(blank").Exists = True Then .PivotItems("(blank)").Visible = False End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |