insert active worksheet name

[abby]

i want to insert the active worksheet name into a cell
where i dont have to type it every time. i have found
the fx for to insert the entire file name & worksheet

=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT
(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH
("\",CELL("filename"),ROW(1:255)))))

but i dont want all that i just want the worksheet name,
how do i do this? your help is greatly appreciated

thanks-abby

 

[Bob Phillips]

Abby,

Take a look at

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

 

[Arvi Laanemets]

Hi

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,36)


Arvi Laanemets