Vba
Solved/Closed
looneybin
Posts
2
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 30, 2015
-
Jul 30, 2015 at 12:39 AM
looneybin Posts 2 Registration date Thursday July 30, 2015 Status Member Last seen July 30, 2015 - Jul 30, 2015 at 01:10 PM
looneybin Posts 2 Registration date Thursday July 30, 2015 Status Member Last seen July 30, 2015 - Jul 30, 2015 at 01:10 PM
Related:
- Vba
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- Vba check if value is in array - Guide
- Vba color index - Guide
- How to open vba in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 30, 2015 at 11:05 AM
Jul 30, 2015 at 11:05 AM
Hi Looneybin,
The code below will add the month to the sheet name. On row 5 you will find on example of excluding a sheet. You can add to this row to exclude more sheets or you can remove the row (as well as row 7) if you don't want to exclude any sheet.
Best regards,
Trowa
The code below will add the month to the sheet name. On row 5 you will find on example of excluding a sheet. You can add to this row to exclude more sheets or you can remove the row (as well as row 7) if you don't want to exclude any sheet.
Sub RunMe()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Name <> "Master" Then
ws.Name = ws.Name & "-" & Format(Date, "Mmmm")
End If
Next ws
End Sub
Best regards,
Trowa
Jul 30, 2015 at 01:10 PM