Thanks a lot - that works! very clever, I didn't realise the filename
function returned the tab name.

"Elkar" wrote:

Try this:

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,999)

Note, that the workbook must be saved in order for this to work.

HTH,
Elkar


"JayJay" wrote:

I want a function like =INFO() or =CELL() that returns the name of the
current worksheet, e.g. =CELL("WorkSheetName"). Is there such a function?