Thanks guys, a loop worked fine because there can only be 1 or 2 sheets
total in the book.
"Mike Fogleman" wrote in message
...
How would I check to see if there is a sheet named "Sheet1" in the active
workbook.

Sub CheckFor New Sheet()

If sheets("Sheet1") does not exist in this WB Then
MsgBox ("No sheet has been added")
Exit Sub
Else
End If

continue...

End Sub