Перейти к содержимому

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