Sub CopieOngletsFeuill1()
Application.ScreenUpdating = False
'=================================================
'Copie de la feuille 1
'=================================================
Sheets("Feuill1").Select
Cells.Select
Selection.Copy
Sheets("Feuill1").Select
Cells.Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
ActiveWindow.Zoom = 70
Application.ScreenUpdating = True
End Sub