Private Sub Worksheet_Change(ByVal Target As Range)
Dim USF As Object
If Intersect(Target, Range("AM6")) Is Nothing Then Exit Sub
With Sheets("Jours fériés")
For i = 2 To 45
If .Range("I" & i) = Target Then
' Set trouve = .Range("I2:I45").Find(Target, LookIn:=xlValues)
' If Not trouve Is Nothing Then
'NomUsf = trouve.Offset(0, 1)
NomUsf = .Range("J" & i)
For Each USF In ThisWorkbook.VBProject.VBComponents
If...