Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name sheet tabs with a cell list
I have a list of names from cell A1..A80. I want to automatically create
that many tabs and name each tab by each name in the list. Can this be automated? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name sheet tabs with a cell list
Sub tester()
Dim rCell As Range For Each rCell In Range("A1:A80") With Worksheets.Add(after:=Worksheets(Worksheets.Count) ) .Name = rCell.Value End With Next rCell End Sub HTH -- AP "deeds" a écrit dans le message de news: ... I have a list of names from cell A1..A80. I want to automatically create that many tabs and name each tab by each name in the list. Can this be automated? Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name sheet tabs with a cell list
Worked great!! Thanks much!
"Ardus Petus" wrote: Sub tester() Dim rCell As Range For Each rCell In Range("A1:A80") With Worksheets.Add(after:=Worksheets(Worksheets.Count) ) .Name = rCell.Value End With Next rCell End Sub HTH -- AP "deeds" a écrit dans le message de news: ... I have a list of names from cell A1..A80. I want to automatically create that many tabs and name each tab by each name in the list. Can this be automated? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |