use sheet name in a cell

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
I have more than a sheet in th workbook (15 sheets).
I need to use the sheet name in certain cells in the sheet itself.
i.e. sheet name is "January" , I need to have it in cell B200.
Is there a way to do this automaticly instead of typing it in the cell?

Thanks in advance
Khalil
 
Khalil, you can use this formula,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) , to return
the sheet name, the file must be saved first for it to work.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top