How can I cause a cell to return the sheet name i.e. sheet 1?
 

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.

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

One way

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34)


you need to have saved the workbook

--

Regards,

Peo Sjoblom


"Matt" wrote in message
...
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.