MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Check to See if Worksheet Exist

Posted by Jeff Arledge on November 11, 2000 12:50 PM

What syntax can I use to change to see if a worksheet named "temp" exists?

Thanks for any help

Posted by Ivan Moala on November 11, 2000 8:14 PM

Jeff use any command that references the sheet
with an error

On error resume next
Exists = sheets("temp").Range("a1")
if err.number = 0 then 'sheet exists do something

Just one way to do this...