Sub Macro3() Dim Cel As Range
' Macro3 Macro
ActiveSheet.PivotTables("Tableau croisé dynamique1") _
.PivotFields("Groupe").CurrentPage = "(All)"
On Error Resume Next
With ActiveSheet.PivotTables("Tableau croisé dynamique1").PivotFields("Groupe")
For Each Cel In Range("ListeNoms")
.PivotItems(Cel.Value).Visible = True
Next Cel
End With
On Error GoTo 0
End Sub