I have a macro that continually deletes and adds a worksheet. Every
time it does this, the default sheet number that Excel assigns
increments (Sheet1, Sheet2 ..etc). I only have 3 sheets in my
workbook, but since I am constantly recreating the 3rd sheet, the
internal Excel-assigned SheetXXX name keeps incrementing. This is NOT
the name of the sheet (which I can change), but the SheetXXX name that
Excel assigns to a new sheet.

1) Is there a way to tell Excel what default sheet number to use.

OR

2) Is there a way to reset the new sheet counter in VBA?

The default new sheet counter continually goes up even if I close and
open Excel. Currently, I'm at Sheet145... but I'm guessing that
something will eventually max out... maybe at Sheet255?

Any ideas?

Thanks.

John