Hi Nicola

The workbook needs to have been saved before this can work.

--
Regards

Roger Govier


"Nicola" wrote in message
...
thanks but it returned #value error!

"Gearoid" wrote:

Try this -

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1))

(cell("filename") returns full information including path to the
current worksheet). The worksheet name is the last piece of
information
in the string and just before the worksheet name appears a closed
square bracket (]). Once you find that in the string, you just need
all
remaining characters in the string after the ]

Ger



Nicola wrote:
thanks but I think my question wasn't clear enough.

I need to enter a formula that returns the name of the worksheet
e.g. if the
worksheet was named June I need the formula to return the result
June - hope
this makes for sense.

"Don Guillett" wrote:

!
sheet3!a1

--
Don Guillett
SalesAid Software

"Nicola" wrote in message
...
Can you tell me how to reference a sheet tab name within Excel.
I can't
remember what to do. Thanks