M
Mike Fogleman
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
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