there are 3 worksheets, named:
worksheet_A
worksheet_B
worksheet_C

in cell B2 for each sheet, how can i display the name of the corresponding
sheet? if the name of the sheet changes so should the contents of B2.

so cell B2 on worksheet_A, will show: "worksheet_A"


thank you.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"rasta" wrote in message
...
there are 3 worksheets, named:
worksheet_A
worksheet_B
worksheet_C

in cell B2 for each sheet, how can i display the name of the corresponding
sheet? if the name of the sheet changes so should the contents of B2.

so cell B2 on worksheet_A, will show: "worksheet_A"


thank you.