Vba
Solved/Closed
looneybin
looneybin
- Posts
- 2
- Registration date
- Thursday July 30, 2015
- Status
- Member
- Last seen
- July 30, 2015
looneybin
- Posts
- 2
- Registration date
- Thursday July 30, 2015
- Status
- Member
- Last seen
- July 30, 2015
1 reply
TrowaD
Jul 30, 2015 at 11:05 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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