title: VBA Store current sheet name to use on new sheet
body: <p>I am wanting to have excel remember the active sheet name and then delete the active sheet and copy a different sheet that i use as a template and rename the new sheet with the stored name from the deleted sheet.</p>
  
  <p>This is the code im using i just need to have it rename the sheet with the stored sheet name</p>
  
  <pre><code>Sub Reset_Work_Order()
  
  Application.DisplayAlerts = False
  ActiveWindow.SelectedSheets.Delete
  
  
  Dim NewSht              As Worksheet
  
  Master_Work_Order.Copy After:=ActiveSheet
  Set NewSht = ActiveSheet
  
  End Sub
  </code></pre>