How to insert tab name of a wrksht into a cell in that worksheet?
 

How to insert tab name of a wrksht into a cell in that worksheet?
 

Check out this web page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/formu..._function.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pat" wrote in message
...

How to insert tab name of a wrksht into a cell in that worksheet?
 

Pat,
Use a formula like


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

The A1 is required, but can actually be any cell you want.

This requires that the file has been saved to disk at least one (that is, it
won't work on new, unsaved workbooks).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Pat" wrote in message
...