Dim Cel_Ref As Range
Set Cel_Ref = Sheets('Devis').Range('B65536').End(xlUp).Offset(1, 0)
With Cel_Ref
.Value = 1
.Offset(0, 1).Value = 2
.Offset(0, 2).Value = 3
.Offset(0, 3).Value = 4
.Offset(0, 4).Value = 5
.Offset(0, 5).Value = 6
.Offset(0, 6).Value = 7
End With