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
Jeff


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

Jeff use any command that references the sheet
with an error routine....eg

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

Just one way to do this...

Ivan