how to check if Worksheets(x) exist?

  • Thread starter Thread starter NEED
  • Start date Start date
Hi
you may try something like
sub foo()
dim wks as worksheet
on error resume next
set wks = worksheets("your_name")
if err.number <>0 then
msgbox "worksheet does not exist"
else
msgbox "worksheet does exist"
end if
on error goto 0
end sub
 
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

To protect user's privacy 1
Excel VBA 0
Excel crashes and restarts when accessing newly created worksheet 2
Macro When Worksheet Opens 3
How to implement subtraction from a range 1
If Worksheet exists, delete it, then re-add it 2
Open Specific Worksheet Using Button Form Control in Excel 0
Check if Range EXISTS 3

Back
Top