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
- 3019 reads
Recent comments
6 years 8 weeks ago
6 years 46 weeks ago
7 years 5 weeks ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 15 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago