Hello, I have the code below, that will change my sheet name to reflect "C1". But I would like to have this code start from sheet two instead of sheet one. Also I would like it to rename every sheet in my workbook after sheet one according to the information in "C1". Appreciate the help.
Sub RenameSheet() Dim rs As Worksheet For Each rs In Sheets rs.Name = rs.Range("C1") Next rs End Sub