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)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=554941

Just an added note here......

the workbook must have been saved prior


Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 07:40:53 -0500, Vito
wrote:


Try this formula pasted in the sheet:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)