can I reference a sheet name in a cell as text?
I want to reference a sheet name within the spread sheet itself as text. I
know I can do it in a header/footer using the &[tab] function, but I'm creating a tool that will be seldom printed. Is this possible? |
can I reference a sheet name in a cell as text?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In some cell HTH GerryK "Karl Barthel" wrote: I want to reference a sheet name within the spread sheet itself as text. I know I can do it in a header/footer using the &[tab] function, but I'm creating a tool that will be seldom printed. Is this possible? |
All times are GMT +1. The time now is 09:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com