View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Sheet names code


Jonah wrote:

Is there away to get the name of a worksheet onto the worksheet itself
in a cell?

Jonah


=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

Returns an empty string until workbook is saved.

Ken Johnson