There are two ways to interpret "name of the current worksheet". If you mean
the function is on, say, Sheet3 in cell A1 and you are on Sheet2 with a
reference to that cell (=Sheet3!A1) and you want to see the name of the
sheet that the sheet the function is actually on, then use this...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
in A1 on Sheet3. But if, instead, what you want is the name of the active
sheet (that is, the sheet name that the =Sheet3!A1 formula is on, then leave
the cell references out of the above formula...
=MID(CELL("filename",FIND("]",CELL("filename")+1,256)
Rick
"RJL007" wrote in message
...
Is there a function in Excel that will return the name of the current
worksheet as a text string?
If not a function, is there some other way of looking up the current
worksheet's name (perhaps VB) and saving/displaying it in a cell?