'Cos 99% of users can just read the sheet name.
anyway no need to have a function for everything that can be provided
using the existing tools/functions :)

Steve


On Wed, 26 Jul 2006 13:37:57 +0100, John wrote:

Amazing! Thank you. It seems strange excel doesn't have something to do
this.

John


Max wrote:
"John" wrote:

What returns the name of a worksheet in a workbook if you are in the
workbook.
for instance: findit(1) gives the name of sheet 1.
Try this technique, from a post by Harlan
Click Insert Name Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK
The above defines WSN as a name we can use to refer to the sheetname
in formulas, etc. It will auto-extract the sheetname implicitly. To
test it, just enter in any cell in any sheet*: =WSN
and the name of that sheet will be returned
*Note: Workbook must be saved for the above to work, ie a name given
to book