.... Dim numCellePiene As Integer numCellePiene = Application.WorksheetFunction.CountA(Range("V41:X41")) If numCellePiene = 3 Then For c = 22 To 24 Cells(41, c) = Cells(41, c + 1) Next End If Cells(41, numCellePiene + 22).Value = 1 ...