Hidden Sheets

[Tim]

Hello All,

I would like to determine if 2 worksheets (usually
hidden) exist before running code. How would I determine
this?

Thanks in advance.

 

[Frank Kabel]

Hi
one way:
sub foo()
Dim wks as worksheet
on error resume next
set wks = worksheets("sheetn")
if err.number <>0 then
msgbox "sheet does not exist"
exit sub
end if
on error goto 0
....
end sub