sub test ()
'==============Déclarations Des Variables==============
With Application
.Calculation = xlCalculationManual
.EnableEvents = False
.ScreenUpdating = False
.Application.DisplayAlerts = False
End With
'===============Bloc N°01=========================
if .........then.......
end if
'===============Bloc N°02==========================
for i=1 to n
nexti
'=================Fin Du Code=====================
With Application
.Calculation = xlCalculationAutomatic
.EnableEvents = True
.ScreenUpdating = True
.Application.DisplayAlerts = True
End With
end sub