<div>
Thanks the solutions, for me seems simplier the option <br />
<br />
Sheets.Add<br />
ActiveSheet.Name = &quot;Orders&quot;<br />
<br />
thanks,
</div>


Thanks the solutions, for me seems simplier the option

Sheets.Add
ActiveSheet.Name = "Orders"

thanks,

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I have three lines in a part of a macro which simply add a new sheet and renames it<br />
<br />
Sheets.Add<br />
Sheets(&quot;Sheet4&quot;).Select<br />
Sheets(&quot;Sheet4&quot;).Name = &quot;Orders&quot;<br />
<br />
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 &quot;Orders&quot;<br />
<br />
thanks,
</div>
</div>


Dear Experts,

I have three lines in a part of a macro which simply add a new sheet and renames it

Sheets.Add
Sheets("Sheet4").Select
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"

thanks,

VBA Excel - Add sheet and rename

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.