mpearce
04-14-2009, 09:55 AM
is there a way to insert a sheet as sheet4 not matter what?
I have code that runs and a new sheet gets inserted. The first time through it is sheet4, this is fine. But if the user chooses to run the code again, the sheet now becomes sheet5. The code references sheet4, so obviously it will error out because sheet4 does not exist in the workbook.
Is there any way around this?
Thanks
I have code that runs and a new sheet gets inserted. The first time through it is sheet4, this is fine. But if the user chooses to run the code again, the sheet now becomes sheet5. The code references sheet4, so obviously it will error out because sheet4 does not exist in the workbook.
Is there any way around this?
Thanks