Sub ChgtNom()
Dim i As Integer
Dim k As Integer
For i = Range("D65536").End(xlUp).Row To 2 Step -1
' Pour plus de 12 mois
If Cells(i, 8).Value > 12 And Cells(i, 8).Value <= 24 Then
Cells(i, 8).Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromRightOrBelow
'Cells(i + 1, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range(i + 1 & ":" & i).Interior.ColorIndex = 4
Rows(i).Select
Selection.Copy
Rows(i + 1).Select
ActiveSheet.Paste
End If
' Pour plus de 24 mois
If Cells(i, 8).Value > 24 And Cells(i, 8).Value <= 36 Then
k = 2
'Cells(i, 8).Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromRightOrBelow
Cells(i + k - 1, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range(i + k & ":" & i).Interior.ColorIndex = 5
Rows(i).Select
Selection.Copy
Rows(i + 1).Select
ActiveSheet.Paste
Rows(i + 2).Select
ActiveSheet.Paste
End If
'Pour plus de 36 mois
If Cells(i, 8).Value > 36 And Cells(i, 8).Value <= 48 Then
k = 4
'Cells(i, 8).Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromRightOrBelow
Cells(i + k - 3, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 2, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 1, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range(i + k & ":" & i).Interior.ColorIndex = 7
Rows(i).Select
Selection.Copy
Rows(i + 1).Select
ActiveSheet.Paste
Rows(i + 2).Select
ActiveSheet.Paste
Rows(i + 3).Select
ActiveSheet.Paste
End If
'Pour plus de 48 mois
If Cells(i, 8).Value > 48 And Cells(i, 8).Value <= 60 Then
k = 5
'Cells(i, 8).Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromRightOrBelow
Cells(i + k - 4, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 3, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 2, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 1, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range(i + k & ":" & i).Interior.ColorIndex = 8
Rows(i).Select
Selection.Copy
Rows(i + 1).Select
ActiveSheet.Paste
Rows(i + 2).Select
ActiveSheet.Paste
Rows(i + 3).Select
ActiveSheet.Paste
Rows(i + 4).Select
ActiveSheet.Paste
End If
'Pour plus de 60 mois
If Cells(i, 8).Value > 60 And Cells(i, 8).Value <= 72 Then
k = 6
'Cells(i, 8).Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromRightOrBelow
Cells(i + k - 5, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 4, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 3, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 2, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Cells(i + k - 1, 8).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range(i + k & ":" & i).Interior.ColorIndex = 10
Rows(i).Select
Selection.Copy
Rows(i + 1).Select
ActiveSheet.Paste
Rows(i + 2).Select
ActiveSheet.Paste
Rows(i + 3).Select
ActiveSheet.Paste
Rows(i + 4).Select
ActiveSheet.Paste
Rows(i + 5).Select
ActiveSheet.Paste
End If
Next
End Sub