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.Count1).End(xlUp)).Cells
Worksheets
("template").Copy after:=Worksheets(Worksheets.Count)
On Error Resume Next
ActiveSheet
.Name myCell.Value
Next myCell
End With
End Sub