Le code que j'utilise :
Sub medianeville()
For Each c In Sheets("Profil").Range("a15:a30")
Dim concurrent As String
concurrent = c
Sheets("Donnees").PivotTables("Donnees").PivotFields("Compagnie d'assurances").CurrentPage = concurrent
Sheets("ville").Cells(13, 2 + i).Value = concurrent
Sheets("ville").Cells(14, 2 + i).Value = Sheets("Donnees").Cells(13, 7).Value
i = i + 1
Next c
Sheets("Donnees").PivotTables("Donnees").PivotFields("Compagnie d'assurances").CurrentPage = "(Tous)"
Sheets("ville").Cells(13, 2 + i).Value = "Tarif global marché"
Sheets("ville").Cells(14, 2 + i).Value = Sheets("Donnees").Cells(13, 7).Value
End Sub