Sub Doublons()
' Traitement doublons Orléans demandes clôturées
Sheets("Feuil1").Select
Dim L As Integer
Range("A3").Select
Do Until IsEmpty(ActiveCell)
ActiveCell.Value = StrConv(ActiveCell, vbUpperCase)
ActiveCell.Offset(1, 0).Select
Loop
Range("A3").Select
' Tri
' ActiveCell.CurrentRegion.Sort Key1:=Range("A3"), Order1:=xlAscending, Header:=xlYes
donnee1 = ActiveCell
ActiveCell.Offset(1, 0).Select
While ActiveCell <> ""
If ActiveCell = donnee1 Then
x = x + 1
Range(ActiveCell, ActiveCell.End(xlToRight)).Select
Selection.Copy
If x = 1 Then
Range("J7").Select
ActiveSheet.Paste
End If
L = ActiveCell.Row + 1
Range(Cells(L, 0)).Select <== ca plante sur cette instruction
Range(ActiveCell, ActiveCell.End(xlToRight)).Select
Selection.Delete Shift:=xlUp
ActiveCell.Offset(-1, 0).Select
donnee1 = ActiveCell
ActiveCell.Offset(1, 0).Select
Else
donnee1 = ActiveCell
ActiveCell.Offset(1, 0).Select
End If
Wend
End Sub