ExcelBanter - Excel 2003 sheet name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 sheet name (https://www.excelbanter.com/excel-discussion-misc-queries/127142-excel-2003-sheet-name.html)

Fiona

Excel 2003 sheet name

Can I make a cell automatically display the sheet name?
Thanks

JE McGimpsey

Excel 2003 sheet name

See

http://www.mcgimpsey.com/excel/formu..._function.html

In article ,
Fiona wrote:

Can I make a cell automatically display the sheet name?
Thanks

David Biddulph

Excel 2003 sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
David Biddulph

"Fiona" wrote in message
...
Can I make a cell automatically display the sheet name?
Thanks

Fiona

Excel 2003 sheet name

Thanks you

"David Biddulph" wrote:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
David Biddulph

"Fiona" wrote in message
...
Can I make a cell automatically display the sheet name?
Thanks

All times are GMT +1. The time now is 12:24 PM.