Sheet name in cell

[Stephen Pain]

Hi all,
I know it is possible as I've seen it done before, but can't remembe
how! I am looking to use the name of a worksheet (as it appears on th
tab) as the contents of a cell?

Any ideas?

Thanks,

Stev

 

[Guest]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Jim May]

one approach:

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

 

[Steve Farrar]

You can also use a user defined function

Enter this in a regular module:

Function mysheet()
mysheet = ActiveSheet.Name
End Function


Then in the cell you select enter the formula "=mysheet()"-- don't forget the "()"