Home |
Search |
Today's Posts |
#1
|
|||
|
|||
NAME TABS IN WORKSHEET FROM LIST
Hi, I'd like to create a tab for each entry from a list off a worksheet. Is
this possible? |
#2
|
|||
|
|||
NAME TABS IN WORKSHEET FROM LIST
Karen
This code will do it (Beware it has no check for duplicates). Copy it into either your workbook or your personal.xls in a standard module, select the range with the sheet names and run the macro Sub CreateAndNameSheets() Dim myCell As Range For Each myCell In Selection Worksheets.Add ActiveSheet.Name = myCell.Value Next myCell End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Karen" wrote in message ... Hi, I'd like to create a tab for each entry from a list off a worksheet. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Tabs | Excel Discussion (Misc queries) | |||
Is it possible to wrap worksheet tabs? | Excel Discussion (Misc queries) | |||
Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) |