is there a formula in Excel that will enter the worksheet name in.

[Guest]

What I want to do if possible is to be able to enter a formula in to a cell
that returns the name of the worksheet that is open. my thinking is that if
we can obtain the path of a file by typing =cell("filename") can i have a
similar formula by typing =cell("worksheet") which would then return the name
on the tab eg Sheet1

 

[duane]

in vba it is activeworkbook.name

you could assign this to a cell in a macr

 

[RagDyer]

Check out these links for your answer.

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

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

--

HTH,

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


What I want to do if possible is to be able to enter a formula in to a cell
that returns the name of the worksheet that is open. my thinking is that if
we can obtain the path of a file by typing =cell("filename") can i have a
similar formula by typing =cell("worksheet") which would then return the
name
on the tab eg Sheet1