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?

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

--
Regards,

Peo Sjoblom



"JayJay" wrote in message
...
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?

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?

Try,

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

Mike

"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?

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?

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



"Mike H" wrote in message
...
Try,

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

Mike

"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?

Thanks Peo, you're right.

"Peo Sjoblom" wrote:

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



"Mike H" wrote in message
...
Try,

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

Mike

"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?

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

"Peo Sjoblom" wrote:

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



"Mike H" wrote in message
...
Try,

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

Mike

"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?