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
|