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
- 3058 reads
Recent comments
6 years 12 weeks ago
6 years 50 weeks ago
7 years 10 weeks ago
7 years 13 weeks ago
7 years 14 weeks ago
7 years 19 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago