ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find a worksheet (https://www.excelbanter.com/excel-programming/306214-find-worksheet.html)

luis

Find a worksheet
 
Hello.
I need to check if a certain worksheet exists in a
workbook.
Is there something like a find worksheet ?

Thanks
Luis

Frank Kabel

Find a worksheet
 
Hi
try something like
dim wks as worksheet
on error resume next
set wks = worksheets("your_name")
on error goto 0
if wks is nothing then
msgbox "worksheet does not exist"
end if

-----Original Message-----
Hello.
I need to check if a certain worksheet exists in a
workbook.
Is there something like a find worksheet ?

Thanks
Luis
.



All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com