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.
|