title: Excel assign copied sheet name as variable
body: <p>I'm trying to copy an existing sheet in my workbook and then I want to use the copied sheet to run the rest of my code. 
  (Sheet3 is the existing sheet, S_Temp is the copied sheet)</p>
  
  <pre><code>Dim s_Temp as string
  Sheet3.copy 
  Activesheet.name = S_Temp
  Sheets("S_Temp").Range("A1").value = "Test"
  </code></pre>
  
  <p>How can I reference to the copied sheet?</p>