Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to find and unlink current worksheet from old worksheet kmjmail Excel Discussion (Misc queries) 3 January 12th 09 10:52 PM
Find worksheet LantzK Excel Discussion (Misc queries) 1 May 23rd 08 05:19 PM
Find Max Value in WorkSheet Corey Excel Worksheet Functions 11 January 14th 07 11:00 PM
find last row on a worksheet tracey Excel Programming 3 February 3rd 04 10:39 PM
Find top of worksheet D. McDonough Excel Programming 1 August 18th 03 10:36 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"