check if a worksheet exist - VBA

[Warren]

Please help.

In VBA, how do I check if a worksheet exists?

Thanks

Warren

 

[J.E. McGimpsey]

one way:

Dim wkSht As Worksheet
On Error Resume Next
Set wkSht = Worksheets("TargetSheet")
On Error GoTo 0
If Not wkSht Is Nothing Then
'worksheet exists
Else
'worksheet doesn't exist
End If