How do I show a tab name in an Excel cell?

[Guest]

Version: Microsoft Office Excel 2003

How can I repeat a sheet's tab name in a cell?

I have a summary sheet which has data fed from multiple other supporting
sheets. The supporting sheets are updated by other users and they modify the
tab name so it reflects their specific subproject effort.

Just as the summary sheet reflects the supporting sheet data, it would be
very helpful to state the tab name so it is clear what the data is
representing (i.e.- the subproject sheet name). I wish to create a link so
if the subproject (tab) name is changed, the summary sheet is automatically
updated.

I had hoped this would be similar to adding the file name and path in a
cell: =cell("filename") however, it is not.

 

[Jake Marx]

Hi Excelling,

Look on Chip Pearson's formula page under Miscellaneous for an example of
how to do this:

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

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

 

[Guest]

Create own module and insert this code:
Public Function name_file()
name_file = ActiveWorkbook.FullName
End Function

In cell write this: =name_file ()

result will full path with name of file.
name_file is your name, if you need different, rename it. ;-)

Peter

 

[Guest]

Or,

Try the response to this FAQ at Debra Dalgleish's site:
http://www.contextures.com/xlfaqFun.html#SheetName

 

[Guest]

For sheet name change function to:
Public Function name_sheet()
name_sheet = ActiveSheet.Name
End Function

result will: name of sheet ;-)