MACROS - how to rename tabs to cell using VBA script
Below is the VBA script to rename tabs to a particular cell in the worksheet
_____________________________
Sub NameTabsAfterCell()
Dim ws As Worksheet
Dim cell As Range
For Each ws In ThisWorkbook.Worksheets
Set cell = ws.Range("A1")
ws.Name = cell.Value
Next ws
End Sub
Watch video MACROS - how to rename tabs to cell using VBA script online without registration, duration hours minute second in high quality. This video was added by user Viet Tran 11 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 151 once and liked it 5 people.