how can you list all of the worksheet names in a file
 

i am trying to write a macro, however i need to know if a worksheet exist
within a file that has been opened before the macro continues,

how can you list all of the worksheet names in a file
 

Chip Pearson posted this function:

Function WorksheetExists(SheetName As Variant, _
Optional WhichBook As Workbook) As Boolean
'from Chip Pearson
Dim WB As Workbook
Set WB = IIf(WhichBook Is Nothing, ThisWorkbook, WhichBook)
On Error Resume Next
WorksheetExists = CBool(Len(WB.Worksheets(SheetName).Name) 0)
End Function

'and you can use it like:
....
if worksheetexists("myname",activeworkbook) then
application.displayalerts = false
worksheets("Myname").delete
application.displayalerts = true
end if

harish wrote:

i am trying to write a macro, however i need to know if a worksheet exist
within a file that has been opened before the macro continues,

--

Dave Peterson