If the sheet has been saved before then you can use:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Jonah" wrote in message
...
Is there away to get the name of a worksheet onto the worksheet itself
in a cell?

Jonah