VBA Excel - Add sheet and rename
Posted on 2010-11-30
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"