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
|