Private Sub Worksheet_Activate()
Application.EnableEvents = False
With [B6].CurrentRegion.Offset(1).Columns(3)
.FormulaR1C1 = "=IFERROR(INDEX(Matrice,""""&RC[-2],""""&RC[-1]),"""")"
.Value = .Value 'supprime les formules, mettre en commentaire pour les voir
End With
Application.EnableEvents = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Worksheet_Activate 'lance la macro
End Sub