Formula > =CELL("filename")

[VegasNath]

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.)

[HansV]

Provide a reference to a cell on the worksheet as second argument:

=CELL("filename",A1)

[VegasNath]