Putting the TAB (name of the worksheet) in a specified cell

[JANICE_SMOKEY]

How can you put the name of the woeksheet (tab) in a specified cell in excel
This message was edited by JANICE_SMOKEY on 2002-04-24 06:32

 

[GeorgeB]

Put this formula into whatever cell you want the Tab name.

=MID(CELL("filename",G223),FIND("]",CELL("filename",G223))+1,LEN(CELL("filename",G223))-FIND("]",CELL("filename",G223)))

 

[shades]

This will put the worksheet name into any cell reference (in this case A1)

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

 

[JANICE_SMOKEY]

I cannot get either of these to work.

 

[Ricky Morris]

Make sure you're using these formulas in a workbook that has been saved.

 

[lenze]

You can also use VBA code

Range("$A$4")=ActiveSheet.Name

Use this in an event procedure such as Activate or Befor Print, or some other macro