Hi,
having a problem with a sheet exists function
i have this
f WksExists(stsht) Then
Else
End If
Function WksExists(wksName As String) As Boolean
On Error Resume Next
WksExists = CBool(Len(Worksheets(wksName).Name) > 0)
End Function
i get a subscript out of range.
shsht is a value from a loop that the if is in.
Hope this is of use, Rob.![[yoda] [yoda] [yoda]](/data/assets/smilies/yoda.gif)
having a problem with a sheet exists function
i have this
f WksExists(stsht) Then
Else
End If
Function WksExists(wksName As String) As Boolean
On Error Resume Next
WksExists = CBool(Len(Worksheets(wksName).Name) > 0)
End Function
i get a subscript out of range.
shsht is a value from a loop that the if is in.
Hope this is of use, Rob.
![[yoda] [yoda] [yoda]](/data/assets/smilies/yoda.gif)