1. If the workbook is saved use below formula in A1.

=MID(CELL("filename",$A$1),FIND("]",CELL("Filename",$A$1))+1,255)

2. Needs vba code. Try to record a macro.


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Excel Menu-2003 for Excel-2007)
If You Can't Excel with Talent, Triumph with Effort.

"Tim H" wrote in message
...
Two questions -
How do I set the name of a worksheet to a cell in a list - say, A1 on
sheet 1?

How do I set the footer to grab data from cells - say, A2 and B2?