View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default How do I get "C4" field in Excel to equal the Worksheeet Name

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

Vaya con Dios,
Chuck, CABGx3




"Daniel" wrote:

As I change the name of a Worksheet I want a field in that Worksheet to show
the Name of the Worksheet