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.

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


"Sheila" (remove underscores) wrote in message
...
Is there any way I can name a sheet from a worksheet cell??

TIA

Sheila