Is a sheet a worksheet?
Is there any better way (less code) to check if a sheet is a worksheet?
Function CheckIsWorksheet(strSheet As String) As Boolean
Dim sh As Object
For Each sh In ActiveWorkbook.Worksheets
If sh.Name = strSheet Then
CheckIsWorksheet = True
Exit Function
End If
Next sh
CheckIsWorksheet = False
End Function
RBS
|