How can I add a new Sheet named for example "PIPPO" (that perhaps already exists) avoiding any prompt with "error run-time 1004"?
sub addPippo
Sheets.Add
Sheets(ActiveSheet.Name).Name = "PIPPO"
end sub
sub addPippo
Sheets.Add
Sheets(ActiveSheet.Name).Name = "PIPPO"
end sub