Naming sheets by cell content

  • Thread starter Thread starter kefee85
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find replace in multiple sheets based on namebox 2
Input sheet with INDEX formula 4
Copying specific value in cell into next empty row on different sheet 1
dragging the row contents of all the sheet to a Index sheet 2
Automate sheets list 1
Populate Data from Summary Sheet 5
Emailing in excel 2003 2
Copy a formula using Vlookup 2

Back
Top