Sub CopieLigneN°() 'Gérard 'quand ajoute ligne d'appel
Sheets("SuivisAppels").Select
On Error Resume Next
Rows("6:6").RowHeight = 100
derlig = Application.Match("zzz", [A:A])
Rows(6).Copy Rows(derlig + 1)
Rows("6:6").RowHeight = 0
derlig.Select
Cells(ActiveCell.Row, 26) = "NC"
Cells(ActiveCell.Row, 1) = ""
Cells(ActiveCell.Row, 5) = Now()
ActiveCell.Offset(0, 2) = ""
ActiveCell.Offset(0, 2).Select
Application.ScreenUpdating = True
ActiveWindow.ScrollRow = Selection.Row
ActiveWindow.SmallScroll Down:=-1
Application.MoveAfterReturn = True
Application.EnableEvents = True
ActiveWindow.LargeScroll ToRight:=-1
End Sub