Essaie avec :
Sub insérer()
Application.ScreenUpdating = False
Cells(6, [A5]).Offset(, 4).Resize(30).Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("D6:D35").Copy
Cells(6, [A5]).Offset(, 4).PasteSpecial Paste:=xlPasteValues
Range("T6:T35").Delete Shift:=xlToLeft
Application.CutCopyMode = False
End Sub
A+