check if worksheet already exists when auto creating worksheets form a list

Hi everyone,

I have a test file that creates new worksheets from a list.
My problem is how do i check to see if the worksheet already exists?
If it exists i want to skip that name on the list and continue down the list.

any help is greatly appreciated.


currently there are 3 worksheets
template, List and Blank

i'm using the following

PHP Code: 

Option Explicit
Sub Add_NameWS2()
Dim myCell As Range
With Worksheets("List")
For Each myCell In .Range(("A1"), .Cells(.Rows.Count, 1).End(xlUp)).Cells
Worksheets("template").Copy after:=Worksheets(Worksheets.Count)
On Error Resume Next
ActiveSheet.Name = myCell.Value
Next myCell
End With
End Sub 


Try this

Option Explicit
Sub Add_NameWS2()
Dim myCell As Range
Dim ValidName As Boolean
With Worksheets("List")
For Each myCell In .Range(("A1"), .Cells(.Rows.Count, 1).End(xlUp)).Cells
    ValidName = True
    Worksheets("template").Copy after:=Worksheets(Worksheets.Count)
    On Error GoTo NameAlreadyUsed
    ActiveSheet.Name = myCell.Value
    If ValidName = False Then
        Application.DisplayAlerts = False
        Worksheets(Worksheets.Count).Delete
        Application.DisplayAlerts = True
    End If
Next myCell
End With
Exit Sub

NameAlreadyUsed:
ValidName = False
Resume Next
End Sub

mrice

thanks that worked a treat 100% what i was trying to do.