Take a look he

http://www.mcgimpsey.com/excel/



In article ,
"Matt" wrote:

I just want the cell to give the title of the sheet. For example: Sheet 1
would be displayed in A2 if A2 had this function.

http://www.mcgimpsey.com/excel/formu..._function.html