how do I place the sheet tab name in my spreadsheet by formula?

Excel 2003

"DRHannay" wrote:

how do I place the sheet tab name in my spreadsheet by formula?

Excel 2003

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

Alternatively, you could write a one-line function in VBA to do the
same thing, easier:

Function SheetName()
SheetName = ActiveSheet.Name
End Function

If this is stored in Personal.XLS where it is always available, you'd
call it on your worksheet with:

=PERSONAL.XLS!sheetname()

Otherwise, if it's stored in the current Workbook (or in an Add-in
which you enable), you could call it without the reference to
Personal.XLS

Chris

Hello,
What would be the formula to add in filename into my spreadsheet?

"Paul Moles" wrote:



"DRHannay" wrote:

how do I place the sheet tab name in my spreadsheet by formula?

Excel 2003

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