Looking for Excel VBA help

[hong]

I'm writing some VBA code in Excel. There's a bit where I copy an existing "template" sheet in a workbook to a new sheet in the same workbook, and then rename it. (This is to do different months in a reporting setup, FYI).

This works as long as a sheet with the new name doesn't already exist. If it does, Excel throws an error. Is there a way to check for the existence of a sheet with the given name, before doing the copy?

Sample code is like this:

Sub makeNewSheet()
Dim target As Workbook
Set target = ActiveWorkbook
target.Worksheets(1).Copy before:=target.Worksheets(1)
' following line fails if "new sheet" already exists in active workbook
target.Worksheets(1).Name = "new sheet"
End Sub

[Nellie]

Dim wsSheet As Worksheet
On Error Resume Next
Set wsSheet = Sheets("NewShtL")
On Error GoTo 0
If Not wsSheet Is Nothing Then
  MsgBox "I do exist"
Else
  MsgBox "I do NOT exist"
End If

or

Dim sh As Worksheet, flg As Boolean
For Each sh In Worksheets
If sh.Name Like "NewSht*" Then flg = True: Exit For
Next
If flg = True Then
  MsgBox "Found!"
Else
  Sheets.Add.Name = "NewSht"
End If

These aren't my snippets, I've just nicked them from elsewhere but they illustrate the two different ways that spring to mind to check wether something exists in VBA.

[hong]

Thank you!

Have I mentioned how much I hate VBA?

[Nellie]

I don't mind it too much but since starting to get to grips with vb.net it is like stepping back into the dark ages at times.