[COLOR=blue]Sub[/COLOR] Sous_total()
[COLOR=blue]Dim[/COLOR] Drlng [COLOR=blue]As Long[/COLOR]
[COLOR=blue]Dim[/COLOR] Derligne [COLOR=blue]As Long[/COLOR]
[COLOR=blue]Dim[/COLOR] Var [COLOR=blue]As Boolean[/COLOR]
Var = [COLOR=blue]True[/COLOR]
Application.ScreenUpdating = [COLOR=blue]False[/COLOR]
rep = MsgBox("Voulez vous créer les classeurs ?", vbYesNo)
[COLOR=blue]If[/COLOR] rep = vbNo [COLOR=blue]Then[/COLOR]
Var = [COLOR=blue]False[/COLOR]
[COLOR=blue]End If[/COLOR]
[COLOR=blue]With[/COLOR] Sheets("a")
Drlng = .Range("A" & Application.Rows.Count).End(xlUp).Row
.Range("K2:K" & Drlng).FormulaLocal = "=SI(J2<>"""";((C2+I2)/((C2+I2)-J2))-1;"""")"[COLOR=green] '<==[/COLOR]
.Range("L" & Drlng + 1).FormulaLocal = "=I" & Drlng & "-H" & Drlng
.Outline.ShowLevels RowLevels:=0, ColumnLevels:=1
[COLOR=blue]End With[/COLOR]
[COLOR=blue]For Each[/COLOR] f [COLOR=blue]In[/COLOR] ThisWorkbook.Worksheets
[COLOR=blue]If[/COLOR] f.Name <> "a" [COLOR=blue]Then[/COLOR]
f.Activate
Derligne = f.Range("A" & Application.Rows.Count).End(xlUp).Row + 1
f.Range("C" & Derligne & ":L" & Derligne).FormulaLocal = "=SOMME(C2:C" & Derligne - 1 & ")"
f.Range("A" & Derligne).Value = "Total"
f.Range("K2:K" & Derligne).FormulaLocal = "=SI(J2<>"""";((C2+I2)/((C2+I2)-J2))-1;"""")"[COLOR=green] '<===[/COLOR]
f.Range("L" & Derligne).FormulaLocal = "=I" & Derligne - 1 & "-H" & Derligne - 1[COLOR=green] '<===[/COLOR]
[COLOR=blue]If[/COLOR] Var = [COLOR=blue]True Then[/COLOR]
f.Copy
ActiveSheet.SaveAs Filename:=ActiveSheet.Name & ".xls"
[COLOR=blue]End If[/COLOR]
[COLOR=blue]End If[/COLOR]
[COLOR=blue]Next[/COLOR] f
Application.ScreenUpdating = [COLOR=blue]True[/COLOR]
[COLOR=blue]End Sub[/COLOR]