Using Sheet Name In Cells

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.

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

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

NB - the file must have been saved for this to work.

For the latter, you'd need code eg:
ActiveSheet.Name = Range("A1")
, assuming the content of A1 is a valid sheet name.

Rgds,
Andy

Paul,

--

HTH

Bob Phillips

"Paul Moles" wrote in message
...
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?