excel auto fill Tab Name

Microsoft Office excel 2007 home & stude...
August 6, 2010 at 06:47:43
Specs: Windows XP
is it possible to auto fill an excel cell with simply the name of the sheet (tab) it resides within?

See More: excel auto fill Tab Name

Report •


#1
August 6, 2010 at 07:58:09
Try this:

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

You have to save the workbook and then recalculate for the Tab name to replace the #VALUE error.


Report •
Related Solutions


Ask Question