title: How to change sheet name to next month automatically
body: <pre><code>Sub Test
      Sheets(“August”).Name=“=Text(Eomonth(Today(),1),””mmmm””)”
  End sub
  </code></pre>
  
  <p>I am trying to change sheet 2’s name to the next month when I run my macro at the end of the month. How do I accomplish this so that I don’t have to do it manually?</p>