Two problems..

1, it returns the whole path, file and sheet name, and the OP asked just for
the sheet name

2. you haven't anchored the formula to the sheet. Try this. Put that formula
in A1. Then go to another sheet, change the sheet name, go back to your
original sheet. Take a look at A1.

--
HTH

Bob Phillips

"lightninbug" wrote in message
...


Hello All,
Maybe I am missing something here but I am required to do this on all
my
work on the job. Select the cell where you want the file name to appear
then
type the formula -
=CELL("filename")
then hit enter.
Like I said maybe I missed a bit if information, wherein this longer more
complicated formula must be used.