Sub For_X_to_Next_Ligne() Dim FL1 As Worksheet, NoCol As Integer Dim NoLig As Long, Var As Variant Set FL1 = Worksheets("Feuil1") NoCol = 1 'lecture de la colonne 1 For NoLig = 5 To Split(FL1.UsedRange.Address, "$")(4) Var = FL1.Cells(NoLig, NoCol) FL1.Cells(NoLig, NoCol) = Var & " -" Next Set FL1 = Nothing End Sub