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 


mrice

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