Excel- Want to create tab names from a list

June 22, 2009 at 10:50:52
Specs: Windows XP
I have a list of about 185 names in an Excel spreadsheet that I want to create an individual worksheet tab for each one with the name in the list as the tab name. I am using Excel 2007. How would I do this so that I don't have to type each one?

See More: Excel- Want to create tab names from a list

Report •


#1
June 22, 2009 at 11:05:57
Assuming your list is in Sheet1!A1:A185, this code should do it.

There are other options for the VBA Add method, such as the order of placement for the new sheets, so take a look at the VBA help files.

Sub AddSheets()
 For Each TabName In Sheets(1).Range("A1:A185")
    Sheets.Add
    ActiveSheet.Name = TabName
 Next
End Sub


Report •
Related Solutions


Ask Question