Naming sheets by cell content

K

kefee85

I have 30 sheets in a workbook and would like to use a5:a34 as the sheet
names. Can this be done easily?
 
B

Bob Umlas

This macro (untested) should do it - assumes you're on the sheet with the
names in A5:A34
Sub Renamer()
dim i as integer
On Error Resume Next
i=1
For each x in Activesheet.range("A5:34")
sheets(i).name=x.value
i=i+1
Next
End Sub

HTH
Bob Umlas
Excel MVP
 
Top