Copy the following code (Verbatim) into any cell (make sure the book is saved
first):

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

--
Regards,
Dave
<!--


"Nigel" wrote:

hi,

can a formula retreive a worksheet name or does it need to be macro based?


thanks,


N.S.