Rename Sheet Based On Cell Value In Excel - VBA Code Included
Chester Tugwell
0:00 / 0:00
Rename Sheet Based On Cell Value In Excel - VBA Code Included
42 606 просмотров · 5 л. назад
Chester Tugwell
149 тыс. подписчиков
42 606 просмотров · 5 л. назад
📽️In this video I demonstrate how to automatically rename a sheet (tab) based on the value entered in a cell on that sheet.
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Here is the code
If Not Intersect(Target, Range("C2")) Is Nothing Then
If Range("C2") = Empty Then
ActiveSheet.Name = "Client Unspecified-" & ActiveSheet.Index
Else
ActiveSheet.Name = Range("C2")
End If
End If