Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logic to Determine if a Data Pivot Field Exist?
Is there a way that you can tell whether or not a Data Pivot Fiel
exists in a pivot table. For example, I want to remove a Data Pivo Field item IF it exists in a pivot table. When I record the removal o this item I get: Range("C7").Select ActiveSheet.PivotTables("Data1").AddFields RowFields:="Quarter" ActiveSheet.PivotTables("Data1").PivotFields("Aver age of Seed 1"). _ Orientation = xlHidden If its not there in the first place I cannot remove it in code. I wan to be able to say if Data1 exists in the Data Pivot Field, then remov it, otherwise do nothing. Thank-yo -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
Routine with fuzzy logic to determine the relative comparison of two strings? | Excel Worksheet Functions | |||
Logic for Placing Multiple field Returns in a Cell | Excel Discussion (Misc queries) | |||
Determine data type for Pivot Field | Excel Programming | |||
determine cell is part of pivot item or pivot field | Excel Programming |