title: Creating a string of month in a column
body: <p>I would like to create a date column formatted via <code>"mmm-yyyy"</code> but starting with next year's date, i.e.</p>
  
  <pre><code>Jan-2020
  Feb-2020
  Mar-2020
  Apr-2020
  May-2020
  Jun-2020
  Jul-2020
  Aug-2020
  Sep-2020
  Oct-2020
  Nov-2020
  Dec-2020
  </code></pre>
  
  <p>My code only created the <em>same</em> month for 12 times. Can any one help me with this? </p>
  
  <p><strong>My current code</strong></p>
  
  <pre><code>Sub demo()
  
  'month recurring till dec
  Dim x As Integer
  Dim i As Integer
  
  For x = 1 To 12
  
      For i = 1 To 12
          StartDate = (month(x + 1)) &amp; "-" &amp; (Year(Now())) + 1
          Cells(i, 1).Value = StartDate
          Cells(i, 1).NumberFormat = "mmm-yyyy"
      Next i
  
  Next x
  
  End Sub
  </code></pre>