"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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---