re
Ok votre code comme ceci
Sub NouvelleFeuille()
Dim xName As String, wM As Worksheet
Set wM = Sheets("FCjour")
wM.Copy Before:=Sheets(2)
On Error Resume Next
xName = InputBox("Please enter a name for this new sheet ", "Adding new sheet")
If xName = "" Then Exit Sub
On Error Resume Next
ActiveSheet.Name = xName
If Err.Number <> 0 Then
MsgBox "Sheet cannot be created as there is already a worksheet with the same name in this workbook", vbCritical, "Existing sheet"
Application.DisplayAlerts = False
ActiveSheet.Delete
Exit Sub
Exit Sub
End If
With Sheets(xName).Cells
.Copy
.PasteSpecial Paste:=xlPasteValues
.Columns("I:Q").Delete
End With
End Sub
Le deuxième code ne vous sert plus, à moins que je ne me trompe.
Si ok et terminé, pensez à
Cordialement