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