Sheet Tab

[Peter Andrews]

How can I put the sheet tab name into a cell (same sheet)?

Thanks

Peter

 

[shah shailesh]

if the workbook is saved use,

=MID(CELL("filename",$A$1),FIND("]",CELL("Filename",$A$1))+1,255)

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Peter Andrews]

if the workbook is saved use,

=MID(CELL("filename",$A$1),FIND("]",CELL("Filename",$A$1))+1,255)

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

How can I put the sheet tab name into a cell (same sheet)?

Thanks

Peter

Thanks that works nicely - now I need to understand how it works.

Peter