Hi
one way

dim wks as worksheet
on error resume next
set wks = activeworkbook.worksheets("your_wks_name")
on error goto 0
if wks is nothing then
msgbox "worksheet does not exist"
end if


--
Regards
Frank Kabel
Frankfurt, Germany

"Raghunandan" schrieb im
Newsbeitrag ...
Hi All,
I wanted to know if there is any method to check if a worksheet
exists in worksheets collection.I want to check this by worksheet name.

Thanks in advance

Regards
Raghu