Sub Macro2()
Dim DL%, L%, texte$
Application.ScreenUpdating = False
DL = Range("A65500").End(xlUp).Row
For L = 3 To DL
If Cells(L, "C") > Cells(L, "B") Then
If Application.CountIf(Range(Cells(2, "A"), Cells(L - 1, "A")), Cells(L, "A")) = 0 Then
texte = texte & Cells(L, "A") & Chr(10)
End If
End If
Next L
Set objShp = ActiveSheet.Shapes.AddShape(msoShapeVerticalScroll, 329.25, 99.75, 346.5, 391.5)
objShp.Name = "Bannière"
ActiveSheet.Shapes("Bannière").TextFrame.Characters.Text = texte
End Sub