Using Name of worksheet in cell

[Ernie Fenwick]

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

 

[Roger Govier]

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)

 

[Ernie Fenwick]

Thanks Roger

Thats great

Ernie

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

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