View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maynard Maynard is offline
external usenet poster
 
Posts: 8
Default clearing VBA worksheet names

I have a VBA program that, when executed, deletes all the worksheets in a workbook and creates new ones. Each time I execute this, the worksheet names ("Sheet1", "Sheet2", etc) aren't cleared...that is, if Sheet1 through Sheet25 are deleted, the new sheets start at Sheet26...even if I close Excel and reopen the workbook. How do I get the newly created sheets to restart at Sheet1?