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

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?

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

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


"Dallas, TX" wrote:

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?

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

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" wrote in message
...
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)


"Dallas, TX" wrote:

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?

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

Actually without a cell reference it returns the name of the last sheet
calculated


--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
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" wrote in message
...
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)


"Dallas, TX" wrote:

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?