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.
"8/1/23" date is in A7. "Meet&Greet" is string is in G7:
Please Login or Register to view this content.
Current code works and renames sheet "Sep23" but I want it to read "Aug23-Meet&Greet".
Thank you for your help!
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Try this !
Originally Posted by KerahJoy
So removing the useless :
PHP Code:Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$7" Then Name = IIf(IsEmpty(Target), "Event" & Index - 1, Format(Target, "mmmyy-") & [G7])
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
That worked thanks Mumps
Thanks Marc
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks