Sub inser_TR()
n = 1
ligne = 5
t2 = "</tr> <tr>"
For m = 5 To Range("H1") * 12 Step 12
t1 = "</tr><tr> <!--" & n & " -->"
Range("d" & m) = t1
Range("d" & m + 6) = t2
n = n + 1
Next
End Sub
[code]Sub inser_TR()
n = 1
ligne = 5
t2 = "</tr> <tr>"
For m = 5 To Range("H1") * 12 Step 12
t1 = "</tr><tr> <!--" & n & " -->"
Range("d" & m) = t1
Range("d" & m + 6) = t2
n = n + 1
Next
End Sub