name of the activesheet

  • Thread starter Thread starter rasta
  • Start date Start date
R

rasta

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)
 
Back
Top