I have created, and um borrowed from the internet multiple vba macro scripts to create worksheets (new tabs) from a template/master sheet ... The most recent being the script below that also makes a link to the tab
The script works great if I am using names.... However I would like to do the same but using date fields. As I understand it, there is an issue using the "/" in the names ... I would ok with just about any format say "." ie 02.09.2022 or a "-" ie 02-09-2022 - doesn't matter ....
Is there a way to create worksheet tabs with dates as the name ?
Thanks in Advance
Sub CreateDateWorksheets()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Sheets("Admin").Range("A1:A10")
Sheets("Template").Copy after:=Sheets(Sheets.Count)
With c
ActiveSheet.Name = .Value
.Parent.Hyperlinks.Add Anchor:=c, Address:="", SubAddress:= _
"'" & .Text & "'!A1", TextToDisplay:=.Text
End With
Next c
Application.ScreenUpdating = True
End Sub
Bookmarks