Can I show a tab name at the top of the sheet?

[djjons]

Hi

Is there a way that anytime I name a tab on a worksheet the name automatically shows up at the top of the sheet,say in cell A1?

Thanks!

 

[VoG]

Try

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

the workbook must be saved for this to work.

 

[djjons]

Many thanks!