how do I display the current worksheet name in a cell?

[Guest]

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?

 

[Peo Sjoblom]

The workbook has to be saved first

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

A1 is irrelevant in this case, what the formula needs is a single cell
reference, it can be any not just A1 and it can be put in any cell including
A1

 

[Guest]

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

 

[Guest]

Try,

=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

 

[Guest]

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

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

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?

 

[Peo Sjoblom]

You need to use a cell reference or it will return the sheet name of the
last sheet that was changed


=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)



--
Regards,

Peo Sjoblom

Try,

=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

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?

 

[Guest]

Thanks Peo, you're right.

You need to use a cell reference or it will return the sheet name of the
last sheet that was changed


=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)



--
Regards,

Peo Sjoblom

Try,

=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

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?

 

[Guest]

Absolutely right, I tried to do a quick cheat on this formula and never
consiodered the consequences

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

You need to use a cell reference or it will return the sheet name of the
last sheet that was changed


=MID(CELL("filename",A1),SEARCH("]",CELL("filename",A1))+1,SEARCH("]",CELL("filename",A1))-SEARCH("[",CELL("filename",A1))-1)



--
Regards,

Peo Sjoblom

Try,

=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

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?