How To: Make cell reference the sheet name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kevin McCartney" wrote in message ... Hi, I'd like a cell to contain the name of the sheet that it is, like the &[TAB] in a footer, any ideas on what function can do this much appriciated. I've looked at INFO function but no help, I know I could do it in code but I don't want to add a module to the report.... get to many questions about, oh your report contains viruses bla, bla. TIA KM |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com