title: VBA - Create new sheet and rename it
body: <p>I am trying to insert a new sheet and then rename it to the current month and year just with one button. For some extra information: I'm planning on removing this button a bit later on so that it will be automatic.</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
    nowMonth = Month(Now)
    nowYear = Year(Now)
  
  ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count)Name = "nowMonth &amp; , &amp; nowYear)
  
  End Sub
  </code></pre>