How can I write a macro to search through a workbook to
determine whether a sheet with a specific name exist?
Thanks.

And another take, .........

If WorksheetExists("YourSheetName") Then ' Do your thing.

Public Function WorksheetExists(WSName As String) As Boolean
'' Checks to see whether a WorkSheet exists.

On Error Resume Next
WorksheetExists = Len(Worksheets(WSName).Name) 0

End Function

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Fri, 12 Sep 2003 14:28:02 -0700, "Lee S." wrote:

How can I write a macro to search through a workbook to
determine whether a sheet with a specific name exist?
Thanks.