Insert sheet

[mpearce]

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

[Bob Phillips]

What happens if there is already Sheet4?

[p45cal]

presumably the code has the likes of
[vba]Sheets.add[/vba] in it, and you refer to it with the likes of
[vba]Sheets("Sheet4").range("A1")[/vba]
Replace with
[vba]Set xxx = Sheets.Add[/vba] and refer to it as
[vba]xxx.range("A1")[/vba] etc.