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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top