Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Create Tabs from Existing Tab
The Last Topic was getting too long for History See http://groups.google.com/group/micro...786c2446bdc465 With much help from Bob, I have a VB code in which I am creating new tabs from a list and existing tab called template. The code works fine with one exception that at the end it wants to create another tab with the same name Template and run to an run time error for duplication of existing tabs and creates a one called Template(2). -------------------------------------Existing Code Private Sub CommandButton1_Click() ' Create tabs from the list ' Bob from microsoft.public.excel.programming 11/28/2006 Dim LastCell As Range, Rng As Range, cell As Range Dim WS As Worksheet Set WS = ActiveSheet Set LastCell = WS.Cells(Rows.Count, "A").End(xlUp) Set Rng = WS.Range("A2", LastCell) For Each cell In Rng If Not IsEmpty(cell) Then Sheets("Template").Copy after:=Worksheets(Worksheets.Count) ActiveSheet.Name = cell.Value End If Next End Sub ----------------------------------------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort tabs on an existing spreadsheet? | Excel Worksheet Functions | |||
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template. | Excel Programming | |||
Rename all existing worksheet tabs | Excel Discussion (Misc queries) | |||
Rename existing tabs | Excel Programming | |||
Macro Help - check existing tabs | Excel Programming |