自己回答吧,请指教,还有高招没有?VBA这么弱,连个判断函数都没有?!
自定义函数:
Function WorkSheetExists(wb As Workbook, sName As String) As Boolean
Dim s As String
On Error GoTo bWorkSheetExistsErr
s = wb.Sheets(sName).Name
WorkSheetExists = True
Exit Function
bWorkSheetExistsErr:
WorkSheetExists = False
End Function