name of the activesheet
=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.
|