Thank you very much. Now lets say you want to delete all the sheets after
this first sheet. It could be anywhere from 2 sheets to 10 sheets.

"Jim Thomlinson" wrote:

Try this

on error resume next
application.displayalerts = false
sheets("Sheet1").delete
application.displayalerts = true
on error goto 0

--
HTH...

Jim Thomlinson


"Anice" wrote:

Does anyone have a suggestion on how you could find a worksheet in a written
code. You have the name, and you want the program to find that sheet and
delete it.

Thank you!