I have three lines in a part of a macro which simply add a new sheet and renames it
Sheets("Sheet4").Name = "Orders"
My problem that sometimes when the macro add a sheet, it is not Sheet4 just Sheet3 for example, and it stops the running. Could you please advise how to do this simplier so maybe in one step adding and renaming? The target would be simply just adding a new sheet as "Orders"