Function to Display Sheet Name in A cell

  • Thread starter Thread starter Michael Santoro
  • Start date Start date
M

Michael Santoro

Does anyone know of a custom function or forumla that
will display the current sheet's name in a cell on that
sheet without the full filename and path?
 
Michael, try this, the workbook must be saved for this to work

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
try

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

the cell reference should be the one containing the formula

hth

Mik
 
Back
Top