Bonjour,
à tester,
Function FeuilExiste(F As String) As Boolean
On Error Resume Next
FeuilExiste = Not Sheets(F) Is Nothing
End Function
Sub Test()
Dim LaFeuille As String, addr As String
LaFeuille = Sheets("Modèle").Range("J3")
If Not FeuilExiste(LaFeuille) Then
Sheets("Modèle").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Range("J3")
addr = "J3,L7:L17,J7:J17,M7:M17,O8:O17,O23:O32,M23:M32,L23:L32,O38:O47,M38:M47,C12:G16,F7:G7,F5,C20:G47,L38:L47"
Range(addr).ClearContents
ActiveSheet.Shapes(1).Delete
ActiveWorkbook.Save
End If
End Sub