worksheet name in cell

[David Obeid]

Hi,

I want to know how to get a worksheet name appear in a cell (say cell A1)?

[darkyam]

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

[David Obeid]

Thankyou so much!

Is there a way to have a worksheet use the content of a particular cell as its name?

Say for example cell A2 contains "David", can I get that (or any other) worksheet in the workbook to automatically be named "David" without use of VBA?

[darkyam]

Sorry, but no. That would require VBA.

[David Obeid]

Thanks anyhow

Much appreciated.