Hi

Into cell where you want the sheet name to be displayed.

P.S. probably you have to replace semicolons in formula with commas!

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"Sheila" (remove underscores) wrote in message
...
Ummm, and where do i put this?

(i know, pain in the neck to be blonde)

Sheila



On Mon, 16 May 2005 08:19:45 +0300, "Arvi Laanemets"
wrote:

Hi

=MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;35)

The workbook must be saved, i.e. the formula doesn't work in freschly
created worlbook, until it is saved.
To refer to another sheet, replace A1 in formula with SheetName!A1.