Sub newfeuil()
Max = 0
For Each sh In Sheets
If Left(sh.Name, 1) = "P" Then
num = CInt(Replace(sh.Name, "P", ""))
If num > Max Then Max = num
End If
Next
Sheets.Add.Name = "P" & Max + 1
End Sub
Sub newfeuil()
Max = 0
For Each sh In Sheets
If Left(sh.Name, 1) = "P" Then
num = CInt(Replace(sh.Name, "P", ""))
If num > Max Then Max = num
End If
Next
Sheets.Add.Name = "P" & Max + 1
Sheets("P0").Cells.Copy Destination:=ActiveSheet.Range("A1")
End Sub
Sub newfeuil()
Max = 0
For Each sh In Sheets
If Left(sh.Name, 1) = "P" Then
num = CInt(Replace(sh.Name, "P", ""))
If num > Max Then Max = num
End If
Next
Sheets.Add after:=Sheets("P" & Max)
ActiveSheet.Name = "P" & Max + 1
Sheets("P0").Cells.Copy Destination:=ActiveSheet.Range("A1")
End Sub