View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T Kirtley T Kirtley is offline
external usenet poster
 
Posts: 82
Default Sheet names code

A formula like:

=CELL("filename")

will return the filename, including the full directory path.

If you only want the filename, excluding the directory path try something
like

=MID(CELL("filename"),LEN(INFO("directory"))+1,99)

HTH,

TK

"Jonah" wrote:

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

Jonah