Showing the tab name by formula in a specified cell?

[Guest]

Is this possible? If so - how? I know it can be done easily as part of
header/footer, but I'd like to do it in the spreadsheet itself (in a specifed
cell).

Thanks

 

[RagDyer]

Try this link for help.

http://www.xldynamic.com/source/xld.xlFAQ0002.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is this possible? If so - how? I know it can be done easily as part of
header/footer, but I'd like to do it in the spreadsheet itself (in a
specifed
cell).

Thanks

 

[Debra Dalgleish]

Chip Pearson has formulas for returning the Sheet Name or the File Name:

http://www.cpearson.com/excel/excelF.htm#FileName

 

[Bernard Liengme]

It cannot be done with existing functions but here is a VBA function
Function Mysheet()
Application.Volatile
Mysheet = ActiveSheet.Name
End Function