Sheet Tab

  • Thread starter Thread starter Peter Andrews
  • Start date Start date
shah shailesh said:
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 said:
How can I put the sheet tab name into a cell (same sheet)?

Thanks

Peter
Click to expand...
Click to expand...

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

Peter
 
Back
Top