Option Explicit
Sub commentaire() 'lundi...samedi
Dim C As Range, Lig&, Col&, Plage
With Feuil5
.Range("U20:u" & .Rows.Count).ClearContents
Lig = 20: Col = Application.Match(ActiveCell.Value, [U19:Z19], 0) + 3
Set Plage = .Range(.Cells(15, Col), .Cells(55, Col))
For Each C In Plage
On Error Resume Next
.Cells(Lig, "u") = C.Comment.Text
.Cells(Lig, "u").WrapText = False
If Err = 0 Then Lig = Lig + 1
On Error GoTo 0
Next
End With
End Sub