Formula > =CELL("filename")
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Formula > =CELL("filename")
I am using a formula in various sheets =CELL("filename") which provides the filename and sheet name, ideal for printing. However, the sheet name does not show correctly, all sheets seem to display one sheet name. How can I overcome this? (Header/Footer is no good for me in this case.)
Nathan
There's no place like home.....
There's no place like home.....
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula > =CELL("filename")
Provide a reference to a cell on the worksheet as second argument:
=CELL("filename",A1)
=CELL("filename",A1)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: Formula > =CELL("filename")
Nathan
There's no place like home.....
There's no place like home.....