Re,
Que veux-tu?
Option Explicit
Public Sub horaires()
Dim nblig As Long, i As Long
Application.ScreenUpdating = False
nblig = Range("B" & Rows.Count).End(xlUp).Row
For i = 13 To nblig Step 1
If Cells(i, "B") <> 0 Then Cells(i, "A") = Cells(i, "B")
Next
End Sub
ou
Option Explicit
Public Sub horaires()
Dim nblig As Long, Ligne as long,i As Long
Application.ScreenUpdating = False
nblig = Range("B" & Rows.Count).End(xlUp).Row
Ligne=1
For i =13 To nblig Step 1
If Cells(i, "B") <> 0 Then Cells(Ligne, "A") = Cells(i, "B")
Ligne = Ligne+1
Next
End Sub