Using Sheet Name In Cells

[Paul Moles]

In Excel Xp how do I get a cell to show the sheet
name,alternatively can I get the sheet name to show the
contents of a cell.

 

[Bob Phillips]

Paul,

--

HTH

Bob Phillips

In Excel Xp how do I get a cell to show the sheet
name,

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

this only works on a saved workbook.

alternatively can I get the sheet name to show the
contents of a cell.

This needs VBA to rename it on demand, it won't reflect changes to the cell
unless you add worksheet change event code. Do you want that?