Rich,

Maybe check the Orientation property of the pivot filed. Try:

Sub test()
If ActiveSheet.PivotTables("PC GROUP").PivotFields("DSD").Orientation =
xlHidden Then
MsgBox "DSD field is hidden"
End If
End Sub



--
Hope that helps.

Vergel Adriano


"badger_rich" wrote:

I have a field in a pivot table named "PC GROUP" with an item named "DSD". I
am wondering if there is a way to programmatically determine if DSD is
currently a hidden (or visible) item.

Thank you for your help.
--
Rich