I am trying to record a macro that deletes a sheet and creates a new one.

The problem is that excel renames sheets.. if I create a new one the first time, it calls it sheet1; if I delete it and create a new one again, it calls it sheet2.

This really messes up the macro, and it mis-references the sheet because the name has changed. I can't even rename the sheet, because it can't find the original sheet1.

Is there any way around this?