My code for renaming sheet using date in a range works but I can't seem to modify it correctly to also include a text string.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A7")) Is Nothing Then
If Range("A7") = Empty Then
ActiveSheet.Name = "Event" & ActiveSheet.Index - 1
Else
ActiveSheet.Name = Format(Range("A7").Value, ("mmmd"))
End If
End If
End Sub
"8/1/23" date is in A7. "Meet&Greet" is string is in G7:
Current code works and renames sheet "Sep23" but I want it to read "Aug23-Meet&Greet".
Thank you for your help!
Bookmarks