In Excel, how do I make a cell equals the sheet name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My worksheet name is BU300, I want the value of a specific cell, in the same
worksheet, to be BU300, without me having to type it. Is there a formula to
do it?
 
That will return the name of the sheet that was last active, you need to add
a cell reference (any cell will do)

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

also the workbook needs to be saved at least one time for it to work


--


Regards,


Peo Sjoblom





N Harkawat said:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)


Dallas said:
My worksheet name is BU300, I want the value of a specific cell, in the
same
worksheet, to be BU300, without me having to type it. Is there a formula
to
do it?
Click to expand...
Click to expand...
 
Actually without a cell reference it returns the name of the last sheet
calculated


--


Regards,


Peo Sjoblom


Peo Sjoblom said:
That will return the name of the sheet that was last active, you need to
add a cell reference (any cell will do)

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

also the workbook needs to be saved at least one time for it to work


--


Regards,


Peo Sjoblom





N Harkawat said:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)


Dallas said:
My worksheet name is BU300, I want the value of a specific cell, in the
same
worksheet, to be BU300, without me having to type it. Is there a formula
to
do it?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top