XLA routines: EE_SheetExists

EE_SheetExists is a simple function that returns whether a sheet exists
Function EE_SheetExists(strSheetName As String, Optional wb As Workbook) As Boolean Dim wbk As Workbook 'http://excelexperts.com/xla-routines-eeSheetExists for updates on this function If IsMissing(wb) Or wb Is Nothing Then Set wbk = ActiveWorkbook Else Set wbk = wb End If On Error Resume Next EE_SheetExists = Not (wbk.Worksheets(strSheetName) Is Nothing) Err.Clear: On Error GoTo 0: On Error GoTo -1 End Function
»
- Nick's blog
- Login or register to post comments
- 3658 reads

Recent comments
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago