Using Name of worksheet in cell
 

Is it possible to pickup the name of a worksheet and use it in a cell. IE
worksheets named 2004, 2005 2006 2007 etc with the name appearing in say
cell reference E1 on each of the worksheets

Regards

Ernie Fenwick

Using Name of worksheet in cell
 

Hi Ernie

provided the Workbook has been saved i.e. it is not a new book called Book1
Enter in E1
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)




--
Regards
Roger Govier

"Ernie Fenwick" wrote in message
...
Is it possible to pickup the name of a worksheet and use it in a cell. IE
worksheets named 2004, 2005 2006 2007 etc with the name appearing in say
cell reference E1 on each of the worksheets

Regards

Ernie Fenwick

Using Name of worksheet in cell
 

Thanks Roger

Thats great

Ernie

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Ernie

provided the Workbook has been saved i.e. it is not a new book called
Book1
Enter in E1
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)




--
Regards
Roger Govier

"Ernie Fenwick" wrote in message
...
Is it possible to pickup the name of a worksheet and use it in a cell. IE
worksheets named 2004, 2005 2006 2007 etc with the name appearing in say
cell reference E1 on each of the worksheets

Regards

Ernie Fenwick