check if a worksheet exist - VBA

  • Thread starter Thread starter Warren
  • Start date Start date
W

Warren

Please help.

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

Thanks

Warren
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
VBA Error Handling 4
How to assign a worksheet in VBA 3
excel isObject or collection exists 1
Search within a single cell for a character 2
Embed information in Worksheet for error checking 0
Utility to flatten/import X12 834 file into Excel 3
Excel crashes and restarts when accessing newly created worksheet 2

Back
Top