Sub comptage()
Dim pvi As PivotItem 'objet
Dim Nbpiv As Long 'Nombre d'items de pon pivot
Sheets("essai").Select
For Each pvi In ActiveSheet.PivotTables("TCD").PivotFields("Label_sho").PivotItems
If pvi.Value <> "(blank)" Then Nbpiv = Nbpiv + Abs(pvi.Visible)
Next pvi
MsgBox Nbpiv
End Sub