how do i know if a worksheet exsist

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yosi_lb - 24 Jan 2007 04:43 GMT

hi everybody
I have a workbook with about 40 worksheets. each worksheet name has a name
of a student

I need to find out if a spesific student has a worksheet in my workbook

thanks

Reply to this Message

David Boothe - 24 Jan 2007 05:08 GMT

> hi everybody
> I have a workbook with about 40 worksheets. each worksheet name has a name
[quoted text clipped - 3 lines]
>
> thanks

Directly from the Excel VBA help file...

This example displays the name of each worksheet in the active workbook.

For Each ws In Worksheets
MsgBox ws.Name
Next ws

Reply to this Message

Jim Cone - 24 Jan 2007 05:42 GMT

The free "XL Extras" Excel add-in can create a Table of Contents
worksheet listing all of the sheets in the workbook.
Each name on the table of contents sheet is hyperlinked to the actual sheet.
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.

Signature

Jim Cone
San Francisco, USA

"yosi_lb" <yosi_lb@bezeqint.net>
wrote in message
hi everybody
I have a workbook with about 40 worksheets. each worksheet name has a name
of a student
I need to find out if a spesific student has a worksheet in my workbook
thanks

Reply to this Message

Michael Bednarek - 24 Jan 2007 10:11 GMT

>I have a workbook with about 40 worksheets. each worksheet name has a name
>of a student
>
>I need to find out if a spesific student has a worksheet in my workbook

Based on a suggestion by Harlan Grove, posted here in December 29
(Message-ID: <1167423302.961638.34480@i12g2000cwa.googlegroups.com>,
Subject: How to list all sheets):

Assuming the worksheet name whose existence you want to determine is in
A1, put this formula into any cell:

=ISNUMBER(ROWS(INDIRECT("'" & A1 & "'!A1")))

It will return TRUE or FALSE.

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

Earl Kiosterud - 24 Jan 2007 18:34 GMT

For a manual lookup, you can get a list of the worksheets by right-clicking
any of the four sheet scroll buttons (lower left).

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> hi everybody
> I have a workbook with about 40 worksheets. each worksheet name has a name
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

Rate this thread: