Work sheet name Reference

[Jjohnson]

Does anyone know of a way to reference the name of a
worksheet into a cell in that worksheet?
Like this.
If the worksheet is names sheet1, is there a way for put a
formula in a cell in that worksheet to reference the name
sheet1. So you can basically print the name of the
worksheet.

 

[Guest]

Try =Cell("filename",a1) in any cell, gives path and
filename and sheet name.

or try

http://www.cpearson.com/excel/excelF.htm#FileName

for more info.

You could always try header & footers in print options

regards

John