Is there a formula that will return the current sheet name?

like: =Cell("Sheetname")

Thanks in advance!

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,999)


In VBA, just:
MsgBox(ActiveSheet.Name)
--
Gary''s Student - gsnu200905


"xp" wrote:

Is there a formula that will return the current sheet name?

like: =Cell("Sheetname")

Thanks in advance!

Just to add to Gary's Student's response.

This formula:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,999)

will give you the name of the activesheet when excel recaluates--not necessarily
the name of the sheet containing the formula.

If you want the name of the sheet that contains the formula, then include a
cell's address in that formula (both spots). I like to use the cell address
that holds the formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,999)

ps. Both these formulas will only work if the workbook has been saved at least
once.

Gary''s Student wrote:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,999)

In VBA, just:
MsgBox(ActiveSheet.Name)
--
Gary''s Student - gsnu200905

"xp" wrote:

Is there a formula that will return the current sheet name?

like: =Cell("Sheetname")

Thanks in advance!

--

Dave Peterson