Abhishek Pratap Singh
First You would like to rename sheets from January 2016 to may 2019.
Next ... You would like to rename those with format from January ... May ... hmm?
There can be once sheet names.
Do ALL sheets will rename?
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
Dim ws As Worksheet
Dim i As Integer
Dim StartDate As Date
StartDate = "01/01/2016"
For i = 1 To ThisWorkbook.Worksheets.Count
ThisWorkbook.Worksheets(i).Name = MonthName(Month(StartDate)) & " " & Year(StartDate)
StartDate = DateAdd("m", 1, StartDate)