Using Name of worksheet in cell

  • Thread starter Thread starter Ernie Fenwick
  • Start date Start date
E

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
 
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)
 
Thanks Roger

Thats great

Ernie

Roger Govier said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top