Showing the tab name by formula in a specified cell?

M

Matt

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
 
R

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
 
B

Bernard Liengme

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