Inserting a worksheet name into the worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to reference a worksheet name in a cell of the worksheet?
When you do this in a header it reads &[Tab], but I can't work out how to put
it into a cell.

I want to do this for a timesheet spreadsheet that has the tab names as
dates and a cell on the worksheet that needs the date too. I always forget
to update the date cell when I create a new worksheet for a new week.

Thanks,
brett
 
Try this formula pasted in the sheet:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255
 
Just an added note here......

the workbook must have been saved prior


Gord Dibben MS Excel MVP
 
Back
Top