title: Excel VBA Beginner - Getting Run time error '9' Subscript out of range
body: <p>I am trying to write a simple macro to change a date format mm/dd/yy to just the month full name. This is what I have using a days worth experience in VBA. I'm missing the error here</p>
  
  <pre><code>Sub ChangeDate()
  
      Dim Last As Integer
      Last = Cells(Rows.Count, 1).End(xlUp).Row
      Dim Counter As Integer
  
      For Counter = 2 To Last
          Dim Month As String
          Month = Left(Worksheets("Sheet1").Cells(Counter, 2), 1)
  
          If Month = "7" Then
              Worksheets("Sheet1").Cells(Counter, 2).Value = "July"
  
          ElseIf Month = "8" Then
              Worksheets("Sheet1").Cells(Counter, 2).Value = "August"
  
          ElseIf Month = "9" Then
              Worksheets("Sheet1").Cells(Counter, 2).Value = "September"
          End If
  
      Next Counter
  
  End Sub
  </code></pre>