Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a worksheet exists in worksheet collection
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a worksheet exists in worksheet collection
See John Walkenbauch's function:
j-walk.com/ss/excel/tips/tip54.htm#func5 -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a worksheet exists in worksheet collection
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check if worksheet exists | Excel Worksheet Functions | |||
Check whether a worksheet exists already | Excel Programming | |||
Worksheet Exists... | Excel Programming | |||
How can I tell if a worksheet exists? | Excel Programming | |||
check if worksheet exists | Excel Programming |