Rename multiple sheets in Excel (One Click Fastest Way)

In this video You will Learn How to Rename multiple sheets in Excel (One Click Fastest Way)
VBA Code:
Sub CWN()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
newName = Application.InputBox("Name", xTiteld, "", Type:=2)
For i = 1 To Application.Sheets.Count
Application.Sheets(i).Name = newName & i
Next
End Sub

Thanks for Watching This Video Subscribe For More updates
subscribe us:
Join our network
Like us on facebook:
Follow us on twitter:

#ExcelTips #ExcelTricks #ExcelTutorial #MsExcel

[arbistorage]

Thanks alot, it did help me a lot especially naming multiple worksheets based on list of names.