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
- 3741 reads

Recent comments
7 years 33 weeks ago
8 years 19 weeks ago
8 years 31 weeks ago
8 years 34 weeks ago
8 years 35 weeks ago
8 years 40 weeks ago
8 years 48 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago