Macro keeps looking for sheet1, won't use sheet2, sheet3 . . .

I have a macro that I use many times in a row. One of the actions it performs is creating a new sheet, which is then deleted before I run the macro again. Of course this first sheet is named "sheet1". However when I delete it (it has to be deleted) and run the macro again it creates a new sheet named "sheet2", and then ceases to function. I tried renaming the sheet as part of the macro, but that didn't work. My question: is there anyway to stop excel from naming the next new sheet created a sequential number. Or might there be another solution to my problem?

Hi salvator. In your code are you referencing the worksheet name for deletion or the object name for deletion. Ex. Sheet1.Delete is the object and Sheets("Sheet1").Delete is the sheet name. I don't believe there is a way to not sequentially number new sheets. There are ways to change both the Name and the CodeName programmatically. If this doesn't help, post your code and I'll take a stab at it. Thanks!

-Greg