Sub Bouton1_Cliquer()
Dim dte As Variant
Dim idx As Variant
dte = Sheets("ARCHIVES").Range("B" & Rows.Count).End(xlUp).Value
If Not IsDate(dte) Then Exit Sub
With Sheets("GÉNÉRATEUR")
idx = Application.Match(CLng(dte) + 1, .Range("C2:L2"), 0)
If Not IsError(idx) Then Application.Goto .Range("C2:L2").Cells(1, idx), True
End With
End Sub