Sub re_name_wst() Dim ws_name As String, new_name As String Dim n As Integer, i As Integer n = ThisWorkbook.Worksheets.Count For i = 1 To n ws_name = Worksheets(i).Name new_name = Replace(ws_name, "2013", "2014") Worksheets(i).Name = new_name Next End Sub