Forum Discussion
AnaPistol
Jun 18, 2019Copper Contributor
Automatically name a new worksheet with a date sequence
Hello, I am trying to create a workbook in which new worksheet names are automatically showing the current date and month. For example, i have a worksheet named May 2019. I would like to insert ...
- Jun 27, 2019
AnaPistol This macro checks if there alreay is a worksheet for the current month. If not it creates one. If there is, it selects it:
Sub AddMonthSheet() Dim sName As String Dim oSh As Worksheet sName = Format(Date, "yyyy-mmm") On Error Resume Next Set oSh = Worksheets(sName) If oSh Is Nothing Then Set oSh = Worksheets.Add End If oSh.Name = sName oSh.Activate End Sub
Twifoo
Jul 05, 2019Silver Contributor
Thanks for the reminder and advice. I humbly accept my imperfection. If it won’t be too much to ask, perhaps you may make the suggestion on my behalf at the relevant space you cited.
EricStarker
Jul 05, 2019Former Employee
Twifoo I mentioned it in case you have an overall suggestion for how we handle Best Responses. I don't know what your overall suggestion is, so I can't really do it for you. I'm also a community manager and that idea board is specifically for ideas from the community itself, not from the staff.
Thanks!
- TwifooJul 05, 2019Silver ContributorNice MOVE, SergeiBaklan. It reminds me to complete the finishing touches of the formulas for the MOVEs on the Chess Games file I plan to share on the 20th, which is World Chess Day. I love Excel and Chess. That file will epitomize such love.
- SergeiBaklanJul 05, 2019Diamond Contributor
Twifoo , EricStarker - here I moved the best response on Jan Karel
- TwifooJul 05, 2019Silver ContributorVery well said, EricStarker. Thanks again for the reminder. I do appreciate it so much.