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
- 2834 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago