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

C

Chip Pearson

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