controlling sheet names when adding sheets to a workbook in a macro

Hi,

I am adding sheets into a workbook (many sheets controlled by some constant values in one tab).

When I did a simple recording of the keystrokes I found this command was recorded

Please Login or Register  to view this content.

This seems to work pretty well on the first time I use it in a newly opened workbook and I get sheet names I can rely on (Sheet1, Sheet2 etc) as I then need to rename them in my macro.

What puzzles me is that if I then delete the sheets I have added (say I added 20) and rerun the macro the first sheet is showing as "Sheet21". If I simply delete the initial sheets, save the workbook, close the workbook and re-open it then I get "Sheet1" again

I am guessing there must be a property that I can set to control the name of the next sheet I add without needeing to close and reopen the workbook

Hope this makes sense, look forward to any help

jmac1947

Thanks to both of the replies, in my very limited VBA knowledge I opted for the solution from protonLeah
(it seemed the simple way) and sure enough it worked.

I learnt something new and finished my macro (double bonus)

Again thanks

Jmac