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